IMP error for only one table?
526056Jul 2 2007 — edited Jul 5 2007I am having a problem with just one table out of this dmp file. I even had the client just export the one table and it is still giving me problems. Any one have any ideas why just one table out of the schema would give me this error?
Thanks in advance
Eric
E:\oracle\Admin\shopkosp\Scripts>set ORACLE_SID=shopkosp
E:\oracle\Admin\shopkosp\Scripts>imp *****/**** FILE=E:\shopkobackup\6-27-07\zonel
ist.dmp tables=zonelist FROMUSER=C3 TOUSER=C3 IGNORE=Y ROWS=Y GRANTS=N INDEXES=y
ANALYZE=y COMMIT=y
Import: Release 9.2.0.1.0 - Production on Fri Jun 29 10:22:53 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export file created by EXPORT:V09.02.00 via direct path
Warning: the objects were exported by OPS$TDAALS1, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses WE8ISO8859P1 character set (possible charset conversion)
. . importing table "ZONELIST"
IMP-00058: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [kcbnew_3], [1], [], [], [], [], [],
[]
IMP-00018: partial import of previous table completed: 34932 rows imported
Import terminated successfully with warnings.
E:\oracle\Admin\shopkosp\Scripts>pause
Press any key to continue . . .
Message was edited by:
eric.wc