snapshot creation problem in 8i

[skgupta]

hello everybody

this problem is very critical for me.

Please read carefully.

i stated my project in oracle 9.2

but due to some problem in the application i was made to switch to 8i
i have exported using a 8i client (exp) and imported in the 8.1.5
database.

the project went on fine for 3 month with out problems.

Now i have to replicate data to other server.


scripts
-------
create snapshot log on abc tablespace bb pctfree 5 pctused 90 with
primary key;

create snapshot abc tablespace aa refresh with primary key for update
as select * from abc@prk;

note : where prk is a public database link

I have created the snapshot log with primary key on existing database
and when I tried to create snapshot on other (8.1.5) server i am
getting
a error

ORA-12028 snapshot type is not supported by master site string

Cause: Pre-Oracle8 master sites are not able to support primary key or
subquery snapshots that are able to perform a fast refresh.

Action: Create a ROWID snapshot or use a master table from an Oracle8
site.

I have never used oracle 7x and the snapshot is behaving like 7x ?why?


with rowid the snapshot are created but with primary they are not why?

please help
***************

[Axr2]

Seems like a bug. Contact support / search metalink.

PS : 8.1.5?! I'd suggest upgrade to a certified version for your platform. In all likelyhood that'll be 8.1.7.