If you use the 9i "exp" program, you cannot use 8i's "imp" to read the file.
However, you can do a SQLNet connect from your 8i ORACLE_HOME to the 9i
database
and use 8i's "exp" to generate an 8i Export.
Hemant
At 05:54 PM Wednesday, you wrote:
Hi Listers,
I want to move a schema from 9i to 8i. When I use export/import, it gives me error
IMP 00010 , please suggest me what should I do in this regard or is there any other method to move schema? Please give me some some lights.
Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://web.singnet.com.sg/~hkchital
All the suffering in the world arises out of wanting happiness for self. All happiness in the world arises out of wanting happiness for others. - Shantideva
Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://web.singnet.com.sg/~hkchital
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------