Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

export from 11g and import to 9i

697105Apr 20 2009 — edited Apr 22 2009

I have run exp from machine runing oracle 9i to export tables from another machine running oracle 11g .Export is working fine but while importing in Oracle 9i it is giving the following errors.

import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00003: ORACLE error 96 encountered
ORA-00096: invalid value for parameter plsql_compiler_flags, must be from among NON_DEBUG, DEBUG, INTERPRETED, NATIVE
IMP-00000: Import terminated unsuccessfully

Can anybody suggest how to do this.

Thanks for your valuable time.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 20 2009

Added on Apr 20 2009

#general-database-discussions

5 comments

641 views