Re: Export Oracle8.0.5 data for Oracle7.3.4 server

On 28 Sep 2004 11:40:56 -0700, harrysheng00_at_hotmail.com (hsheng) wrote:

>Hi, experts
>
>I know Oracle80 and Oracle7 are too old. But reality is reality, I am
>having a requirement to export data from Oracle 8.0.5 on MS windows
>platform, and import these data into Oracle 7.3.4 on HP-UX platform.
>Not just table data, must be a whole schema; because I do not have any
>source code for the schema objects (most importantly the triggers).
>Unfortunately I do not have the Oracle 7 export utility for MS
>windows. Please, I need help to accomplish this task.
>
>Thanks in advance.

You can do with 7.3.4 exp on HP-UX and use tnsnames.ora on HP-UX to connect to the winblows database.
Also you can use Toad to extract the table definitions and the data.

Any good reason why your employer loves to be in the stone age and wants to keep you out of the real world?

--
Sybrand Bakker, Senior Oracle DBA