Re: Exporting Tables from 9i to 7.3 DB
- From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- To: jfpark137@xxxxxxxxx
- Date: Fri, 9 Nov 2007 07:58:22 -0600
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.3database, 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
Other related posts:
