Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Can't create snapshot - HELP!

Can't create snapshot - HELP!

From: Patrick Murphy <pmurphy1_at_gate.net>
Date: Tue, 22 Dec 1998 20:21:23 -0500
Message-ID: <75pgnb$1glu$1@news.gate.net>


I'm on a 8.0.5 database trying to create snapshots from our production database on 7.3.3. Here's my DDL:

CREATE SNAPSHOT owner.table_name
TABLESPACE valid_tablespace_name
PCTFREE 5
INITRANS 1
MAXTRANS 255
STORAGE ( INITIAL 250K NEXT 250K MINEXTENTS 1 MAXEXTENTS 200  PCTINCREASE 0)
REFRESH FAST
START WITH to_date('23-DEC-1998 01:00:00', 'DD-MON-YYYY HH:MI:SS') NEXT trunc(sysdate +1) + 1/24 AS
select * from table_name_at_valid_dblink_name;

Here's my error:

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

I've tried complete and force refresh. I've verified that my database link works. Can someone please help?

Patrick Murphy
Cutrale Citrus Juices USA, Inc. Received on Tue Dec 22 1998 - 19:21:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US