I need to upgrade my database from 7.3 to 8i, if I'm using exp/imp: 'exp system/manager full=Y' from 7.3 then 'imp system/manager full=Y ignore=Y' to 8i.
Can I use the above command if the database is under the xxx schema?
What can I do to make sure all the packages, triggers, constraints, procedures... are imported properly? Is there a better way to do it besides the above command? Any suggestions? Thank you.
03-21-2001, 02:09 AM
By using 'exp file = backup.dmp userid = system/manager full = Y compress =Y log = backup.log', u are actually exporting all the packages, triggers, procedures..... into the dmp file. If you only have one schema, then u do not need to specify the schema to export from. From the backup.log, you are able to see the process of the export. Good luck! :)
03-21-2001, 04:54 AM
I am undergoing through a similar project.I have formed a set of procedures which i am writing for your reference
The Export Import Method of Data migration
1.Point your environment variables to the old instance and then perform a full export as follows: