Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Can't create snapshot - HELP!
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