| Database Dump Files [message #59634] |
Wed, 10 December 2003 12:42  |
LT
Messages: 29
Registered: August 2003
|
Junior Member |
|
|
Does anyone know if the following is Ok?
About to roll out a new 9.2.0.1.0 database that mirrors our present production 8.1.7.0.0. Dont anticipate any problems but just incase want to know if anyone has discovered any issues with taking a full system dump from a 9.2.0.1.0 database and loading it on to a 8.1.7.0.0 database.
Appreciate your most prompt response.
Regards.
|
|
|
|
|
|
| Re: Database Dump Files [message #59676 is a reply to message #59646] |
Mon, 15 December 2003 11:55  |
Prasad
Messages: 104
Registered: October 2000
|
Senior Member |
|
|
Hi Thiru
Is it really required to run 8i exp.sql in 9i database.there is no problem with dictionary updation.I have tested at the user level not at database level, everything goes fine.
Can u elaborate what is u'r real idea behind running catexp8.sql on 9i database.
Thanks and Regards
Prasad
|
|
|
|
| Re: Database Dump Files [message #59685 is a reply to message #59676] |
Tue, 16 December 2003 03:47 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Prasad,
The idea is to make the data dictionary compatible with the exp binary. The 9i data dictionary 'may' be compatible with the 8i exp binary and it 'may' work fine without any errors, but running the 8i exp.sql against the 9i database will ensure that. Once after your 8i export is done, you should restore the 9i data dictionary views related to exp/imp by running the 9i catexp.sql as user sys.
Oracle may or may not guarentee this downward compatibility(ie data dictionary & binary ) across all versions and hence this is the procedure I follow and it has worked great from 7.0 through 9.2.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
