ORA-26059: Data is too large for column Name during import

Error:

While importing data of a table getting below error

Starting “SYSTEM”.”SYS_IMPORT_TABLE_01″:  system/********@QAT2 directory=EXP_DIR dumpfile=TABLE_EXP_18052018.dmp logfile=TABLE_IMP_18052018.log remap_schema=SCOTT:TIGER tables=TIGER.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 Name
Job “SYSTEM”.”SYS_IMPORT_TABLE_01″ completed with 1 error(s) at 11:04:14

Solution:

The error is due to Name data size.
Instead of data only use TABLE_EXISTS_ACTION=REPLACE to import.
This is replace the total table structure from target and import the table.

  • September 18, 2018 | 17 views
  • Comments