Oracle: Create table from Snapshot
Posted: Tue Sep 20, 2005 5:50 pm
[PROBLEM]
Imagine 2 databases with a working snapshot replication - so the data can not be written in both DBs.
...now what to do if one of those databases is lost due to a crash or whatever?
[SOLUTION]
It is possible to create tables and fill them with the content from snapshots:
...where "linkToOtherDB" is a database link to the "still running" database.
Imagine 2 databases with a working snapshot replication - so the data can not be written in both DBs.
...now what to do if one of those databases is lost due to a crash or whatever?
[SOLUTION]
It is possible to create tables and fill them with the content from snapshots:
Code: Select all
CREATE TABLE myuser.mytable AS SELECT * FROM myuser.mytable@linkToOtherDB;