Home » Server Options » Replication » Updateable Snapshots Creation
Updateable Snapshots Creation [message #75491] Wed, 07 April 2004 10:19 Go to next message
Sanket Pradhan
Messages: 3
Registered: April 2004
Junior Member
I am creating the following snapshot using the following statement:

create snapshot tmp_snapshot
refresh complete with rowid
start with sysdate
next (trunc(sysdate) + 1 + 21/24)
for update as
select
sysdate , 'Y' status
from dual@dblink1;

While creating the snapshot, I get the error ORA-12013 : updatable snapshots must be simple enough to do fast refresh
I am creating this snapshot in Oracle 9i but the source database is 8i.I am able to create a snapshot when both source and destination databases are in 9i.

Pls help in resolving this issue.

Thanks.

-- Sanket.

Report message to a moderator

Re: Updateable Snapshots Creation [message #75506 is a reply to message #75491] Wed, 16 June 2004 11:33 Go to previous message
Ravi Venu
Messages: 1
Registered: June 2004
Junior Member
You need simple snapshots to make it updatable.
like
create m view ...
refresh fast for update
as select * from schema.table@link;

Report message to a moderator

Previous Topic: Help from OCP's
Next Topic: Replication
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 30 12:04:47 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.