Creating Snapshot in Oracle 8.0

[OraWiz]

Hi all,
I am in the process of replicating my production Database.
I hv created the reqd link in Dev. Databae and Snapshot log for the tables in Production schema.
My problem is when I am creating snapshot in Dev. Database I am getting an error ora-12014 'so&so' table does not contain Primary key constraint. But my production table very well have Primary key and It is enabled also...

What could be the problem.
Rgds
Sebastian

 

[spicysudhi]

whts ur oracle version, there is a compatability problem in this (WITH PRIMARY KEY). Try the WITH ROWID option instead.

sudhi

 

[OraWiz]

Dear Sudhi,
I am using Oracle 8.0.5
is this version having the compatability problem ?
Rgds
Soji

 

[OraWiz]

Hello all
In my remote database I am issuing following command (my link is working properly)

CREATE SNAPSHOT G_SUPPLIER_MSTR WITH ROWID
AS SELECT * FROM G_SUPPLIER_MSTR@LINIAS

the WITH ROWID is not accepting in my command.
If I omit "WITH ROWID" by default it will try to create a primary key replication, which I presume is not supporting this version.( I have created a snapshot log in my production database WITH ROWID)

Any work around, I have refer what ever possible oracle documents. But in the document same syntax of the command is given. driving towards the wall.

I hope somebody will be able to help me out

Rgds.
Sebastian

 

[karluk]

You have a syntax error in your create statement. It should be

CREATE SNAPSHOT G_SUPPLIER_MSTR REFRESH WITH ROWID
AS SELECT * FROM G_SUPPLIER_MSTR@LINIAS

 

[OraWiz]

Thanks a lot.
Now its working..