Originally posted by oddster
How would you migrate a database from 8.1.7.2 on SUN to 8.1.7.4 on HP?
I would clone the database. Do you know how to do that?

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.
Aye, with prebuilt tables you need the dumps, right.

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$?
It depend son how you build the MV log. Usually it is the primary key. You should run select * from DBA_MVIEW_LOGS: to check this.

To see the snapshots registered in the database, run select * from DBA_REGISTERED_SNAPSHOTS; It will tell you the snapshot site and even the query text.