Re: Can't create snapshot - HELP!

I think you have to use the option "WITH ROWID".

Didier

Patrick Murphy a écrit :

> 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 Wed Dec 23 1998 - 04:54:31 CST