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 :
after which point I get an application error and exp terminates.
C:\Documents and Settings\>C:\oracle\ora92\bin\exp.exe file=expdat1.dmp
Export: Release 220.127.116.11.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 18.104.22.168.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)
If I run this utility against my 9i database, the export completes properly.
Any ideas what is happening ?