This content has been marked as final. Show 4 replies
1 person found this helpful
That step you'll want to do as part of the new instance creation, before adding tablespaces and adding users.
5. Run the catalog.sql and catproc.sql in Server2
Export/Import can be fine, if you're patient, or don't have large tablespaces.
The #7 and #8 aren't needed since its a new instance and the system catalog is already at the 11g version.
Also may want to check out transportable tablespaces, it only takes a few moments to expdp the tablespace catalog info, plus time for copying the datafiles and impdp the tablespace metadata.
The only caveat for TTS is the system tablespace, with user procedures/functions/sequences and other items will not transport, so it will take an exp or expdp of the schema(s) to get code + sequences into the new database instance.
Your steps are almost correct. You do not need part of Step 7 (startup upgrade and run the catupgrd.sql) - the import will perform the "upgrade" automatically.
See the steps here http://docs.oracle.com/cd/E11882_01/server.112/e23633/expimp.htm#i262220
So I don't have to do anything for the 64 bit to 32 bit.
Correct - the export/import will take care of it1 person found this helpful