Re: Exporting Tables from 9i to 7.3 DB

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Fri, 9 Nov 2007 07:58:22 -0600
Message-ID: <de807caa0711090558g798ccef3i704388d775be2985@mail.gmail.com>

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

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

Received on Fri Nov 09 2007 - 07:58:22 CST