Originally posted by julian
However, your strategy is not the best possible. There is no need to import MVs.
How would you migrate a database from 8.1.7.2 on SUN to 8.1.7.4 on HP?
We had to use export/import. This is a very large database and the snapshots are on prebuilt tables, which have extra columns containing information on refresh times needed by the app.

We cannot stop the snapshots being created on full import.

Do you know what the criteria for regitsering a snapshot at the master is? e.g. does it use global name, snapshot id and/or last refresh time to determine waht to refresh and if a new snapshot should be registered in reg_snap$?

Brgds,

Andy