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
-- //www.freelists.org/webpage/oracle-l
