Error:
While importing data of a table getting below error
Starting "SYSTEM"."SYS_IMPORT_TABLE_01": system/********@SID directory=test_dir dumpfile=dump_25052017.dmp logfile=dump_25052017.log remap_schema=OldSchema:NewScheam tables=NewScheam.table content=data_only parallel=2
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object NewScheam.table failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
ORA-26059: Data is too large for column Col_3
Job "SYSTEM"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 11:04:14
Solution:
The error is due to Col_3 data size,So try with TABLE_EXISTS_ACTION=REPLACE to import the latest data structure and data of the table.
While importing data of a table getting below error
Starting "SYSTEM"."SYS_IMPORT_TABLE_01": system/********@SID directory=test_dir dumpfile=dump_25052017.dmp logfile=dump_25052017.log remap_schema=OldSchema:NewScheam tables=NewScheam.table content=data_only parallel=2
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object NewScheam.table failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
ORA-26059: Data is too large for column Col_3
Job "SYSTEM"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 11:04:14
Solution:
The error is due to Col_3 data size,So try with TABLE_EXISTS_ACTION=REPLACE to import the latest data structure and data of the table.
No comments:
Post a Comment