Re: Exporting Tables from 9i to 7.3 DB

1. I don't think this will work without running the 7.3.4 version of catexp (and it probably wont' even at that)
2. I dont' think database links between 9i and 7.3.4 will work (at least I was never able to get them to work)

Another option would be to unload the data via CSV files and create sqlloaders for the tables.

Dennis Williams wrote:
> James,
>
> Just a couple of ideas for you.
> 1. Usually you would run the old exp binary against the new database.
> In this case, you could try executing the 7.3 exp against your 9i
> database. Not sure if this method would work across two major versions
> though. The bigger question is if you could trust the result.
> 2. Create a db link between your 9i database, send the data to your
> 7.3 database, and export from there.
> 3. If this is on Unix, or you have a Unix server somewhere, create the
> exp file from 9i, then run the dump file through the Unix command
> "strings". This will create you a file of the SQL statements. If you
> are only talking about minor updates, you should be able to do some
> minor editing and create your client a sql file to execute.
> 4. Tell your client you can't support them on 7 any more and neither
> can Oracle.
>
> Dennis Williams

--
http://www.freelists.org/webpage/oracle-l