Database Software

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!

exp imp issue from higher version to lower version

mafaizJun 27 2012 — edited Jun 27 2012

Hi,
I have an export dump file which was taken from 11g database(11.2.0.2.0) and trying to import into lower version of the database 9i(9.2.0.6.0), unable to complete the process.
Two ways i have found and tested in my test db
1)TNS entry of 9i database has been put into 11g database
a)Export dump was successfuly taken from 11g db
b)Getting below error,while import into 9i database
IMP-00058: ORACLE error 6550 encountered
ORA-06550: line 1, column 33:
PLS-00302: component 'SET_NO_OUTLINES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignoredIMP-00000: Import terminated unsuccessfully
2)TNS entry of 11g database put into 9i database version.
a)During export (trying to take exp dump from 11g db in 9i exp utility),getting below error
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
EXP-00000: Export terminated unsuccessfully
Kindly advice me to overcome from this issue.

Regards,
Faiz