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;