How to export an old oracle database? 1

[telemorgan]

Good Morning,
I have an old oracle73 database that I need to perform a full database "export" on. The oracle environment resides on an old Winnt server. I have the system pw. How can I perform this full export?

Thanks, a little green when it comes to oracle especially on an old environment like this.

 

[SantaMufasa]

Morgan,

I highly recommend tht you export, individually, each of the schemas that you want to reside in the new database. (I.e., do not attempt to do a "full database export" per se.)

You did not mention the target version into which you are importing the Oracle 7 data; Metalink Note:132904.1 says that a full import into 10g from a full export from 7 does not work, but you should be able to do a schema-by-schema Oracle 7 export, then an Oracle <newer version> import.

The export ("exp") syntax for an Oracle 7 export is virtually the same as newer exports. You can get a full disclosure of available parameters for Oracle 7 export by issuing this command at your o/s prompt:

exp help=y

If you are not familiar with (Oracle 7) "exp", then interactive mode is the easiest enviroment. At your o/s command prompt simply enter "exp". This will then prompt you for values (or defaults) that should get you through the exporting. Do this iteratively for each of the schemas you want to import into the new environment.

Once you have completed your exporting, just run the "imp" commands on the target system.

Let us know your results/findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[telemorgan]

Thank you, very helpful.

I was eventually able to get the exp to complete successfully. Had to play around with the parameters (userid, file, log, buffer, etc.) a little bit. I couldn't find an "exp" to run so I tried the "exp80" and it worked.

I did perform a "Full" dump of the data and didn't go schema by schema. We are at ver. 73 now and will most likely be going to 9i to match our other oracle environments. Can I do a full dump from 73 into 9i?

Thanks again.