Re: Help! "ORA-12028: snapshot type is not supported by master site."

Roger Sprague schrieb:

> The database link works.
>
> The database link type is not public.
>
> I have tried all three refresh types.
>
> I am querying a table within the snapshot not a view.
> That would make this a simple snapshot.
> "SELECT * FROM O911IA.TSLIC_at_SNAP_O910IA"
>
> When I click on create in the Create Snapshot Dialog Box
> I recieve the error.......................
>
> "ORA-12028: snapshot type is not supported by master site."
>
> The master site is Oracle 7.3.3
> I am able to query the table "TSLIC" independantly of the snapshot.
>
> The local database is Oracle 8.0.
>
> Both databases have different sids and different hosts.

 Hi Roger,

there are some important differences between Oracle7 and Oracle8 snapshots. In Oracle7 the server identifies changed rows with rowid and in Oracle8 the server identifies changed rows with the primary key. So if you have a master site Oracle7 and a local database Oracle8 and you what to use a snapshot log for fast refresh then you must create a snapshotlog with rowid.

regards

Kalle Schubert

--
_____________________________________________________________________________

Karl-Heinz Schubert   Tel.  : +49 89  75981-245
Senior Consultant   Fax   : +49 89  75981-150
Notkestraße 15
22607 Hamburg          e-mail: kschuber_at_de.oracle.com
_____________________________________________________________________________

Opinions are mine and do not necessarily reflect those of Oracle
Corporation