Skip to Main Content

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!

Oracle9.2.0.8 (AIX) migrated to Oracle11.2.0.4 (Linux), using imp to report errors when importing by

3638008Jul 15 2019 — edited Jul 18 2019

hi,all

Oracle9.2.0.8 (AIX) migrated to Oracle11.2.0.4 (Linux), using imp to report errors when importing by user.

The command is:

imp userid=\"/ as sysdba\" file=/data/dsods_full.dmp log=/data/DB_DZB_imp.log fromuser=DB_DZB feedback=10000 buffer=1024000000 ignore=y

Importing multiple users, a series of errors occurred:

IMP-00020: long column too large for column buffer size (7)

IMP-00017: following statement failed with ORACLE error 942:

IMP-00003: ORACLE error 942 encountered

IMP-00017: following statement failed with ORACLE error 942:

ORA-00942: table or view does not exist

IMP-00028: partial import of previous table rolled back: 32767 rows rolled back

IMP-00034: Warning: FromUser "." not found in export file

ORA-04052: error occurred when looking up remote object DB_ODS.T_ZDSY_NSR@ODS595

ORA-00604: error occurred at recursive SQL level 1

ORA-12170: TNS:Connect timeout occurred

ORA-04045: errors during recompilation/revalidation of DB_NSPG.P_PG_SJCJ_INIT

ORA-12170: TNS:Connect timeout occurred

IMP-00058: ORACLE error 1438 encountered

ORA-01438: value larger than specified precision allowed for this column

ORA-00957: duplicate column name

IMP-00041: Warning: object created with compilation warnings

ORA-00604: error occurred at recursive SQL level 1

IMP-00003: ORACLE error 1917 encountered

ORA-01917: user or role 'TC_ADMIN_ROLE' does not exist

thanks all.

Comments
Post Details
Added on Jul 15 2019
1 comment
277 views