EXPERT RESPONSE
In order to import when going down a version, use the lower version's export utility. So in your Oracle 9i database, create a TNS alias in your tnsnames.ora config file that points to your 10g database. Then invoke the 9i export utility and use the "@tns_alias" with your username to connect to the 10g database similar to the following:
exp userid=system@10g_database_alias
file=my_dump.dmp full=y
Now that you have created a 9i dump file from the 10g database, you will be able to import into the 9i database without problems.
|
