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.