Re: DB Link problem: ORA-12028: snapshot type is not supported by master site

From: Yass Khogaly <ykhogaly_at_us.oracle.com>
Date: Wed, 17 Nov 1999 13:10:36 -0800
Message-ID: <80v209$4ct$1@inet16.us.oracle.com>

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.

"The Views expressed here are my own and not necessarily those of Oracle Corporation"

NetComrade <andreyNSPAM_at_bookexchange.net> wrote in message news:3833006a.86580733_at_news.earthlink.net...
> CREATE SNAPSHOT swhoops.user_details
> PCTFREE 30 PCTUSED 50 TABLESPACE swhoopsdat
> STORAGE (INITIAL 100M NEXT 50M PCTINCREASE 0)
> USING INDEX TABLESPACE swhoopsind
> REFRESH FAST
> AS
> SELECT * FROM user_details_at_hoop.world;
> SELECT * FROM user_details_at_hoop.world
> *
> ERROR at line 7:
> ORA-12028: snapshot type is not supported by master site
>
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>
Received on Wed Nov 17 1999 - 15:10:36 CST