| Import errors from Windows to Unix [message #72559] |
Wed, 16 July 2003 11:15 |
Eddy Confer
Messages: 17
Registered: January 2002
|
Junior Member |
|
|
I export a database from Windows NT. The dump file is placed on an ftp site, picked up and eventually moved to UNIX where an attempt is made to import. The import appears to go well until the end when the following errors occur. Prior to getting these errors it appears that data was imported successfully into all tables but attempts to compile objects such as stored procedures, functions, triggers, etc. are all failing Then the errors appear. Can anybody help?
About to enable constraints...
IMP-00017: following statement failed with ORACLE error 6502:
"BEGIN SYS.DBMS_REPCAT_MIG.CLEANUP_IMPORT('EXPORT:V08.01.07'); END;"
IMP-00003: ORACLE error 6502 encountered
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 6502:
"BEGIN SYS.DBMS_REPCAT_MIG.CLEANUP_IMPORT('EXPORT:V08.01.07'); END;"
IMP-00003: ORACLE error 6502 encountered
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 1
IMP-00009: abnormal end of export file
Import terminated successfully with warnings.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
