I need to export from a 11g database into a 9i database. I am running the utilities from my local machine where I have both 11g and 9i client installed. My default home is 11g. Since I need to use the lowest DB version to export from, I am invoking the export utility like :
C:\Documents and Settings\>C:\oracle\ora92\bin\exp.exe file=expdat1.dmp
Export: Release 184.108.40.206.0 - Production on Tue Jan 27 12:50:02 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses UTF8 character set (possible charset conversion)
after which point I get an application error and exp terminates.
If I run this utility against my 9i database, the export completes properly.
In the past I had an awkful lot of errors doing 18.104.22.168 exports connecting against 10g databases (mainly due to the new datatypes), I solved the issue only upgrading 9i home to 22.214.171.124 (the last patchset in the ocasion, today 126.96.36.199 is the last) : try it.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
I could not find Oracle Home Switch, so I used the free tool Oracle Locator Express. After changing the homes, I can switch back and forth between my 9i and 11g homes to run the exp and imp utilities. Thanks.