moving 9.2.0.7 database to 9.2.0.8
We have an old server that I have a database on, running 9.2.0.7. I need to find a temp home for the database until the vendor is ready to upgrade to 11G, and the only other 9i server I have is running 9.2.0.8.
Just wondering, I typically move databases by cloning with the datafiles from a recent backup, rebuild the control file and open resetlogs.
Would it be better to patch the 9.2.0.7 to 9.2.0.8 (if I can find the patch set) then move, or move the datafiles over, startup upgrade and run the necessary scripts on the dictionary?
Or, in this case, perhaps create the 9.2.0.8 database and just import the schemas from 9.2.0.7?
Just wondering, I typically move databases by cloning with the datafiles from a recent backup, rebuild the control file and open resetlogs.
Would it be better to patch the 9.2.0.7 to 9.2.0.8 (if I can find the patch set) then move, or move the datafiles over, startup upgrade and run the necessary scripts on the dictionary?
Or, in this case, perhaps create the 9.2.0.8 database and just import the schemas from 9.2.0.7?
0