Wednesday, October 6, 2021

Oracle Database IMPDP Error

Error:

import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
Warning: possible data loss in character set conversions
Starting "*DatabaseName*"."SYS_IMPORT_FULL_01":  
*DatabaseName*/******** DIRECTORY=MYDIR DUMPFILE=BackupName.DMP LOGFILE=BackupName.log PARALLEL=8 remap_schema=OldDBName:NewDbName remap_tablespace=OldTbName:NewTbName,OldTb1Name:NewTb1Name, remap_Table=dbname.table_name:newdbName.tableName table_exists_action=TRUNCATE
Processing object type TABLE_EXPORT/TABLE/TABLE
Table "*DatabaseName*"."table_name" exists and has been truncated. Data will be loaded but all dependent metadata will be skipped due to table_exists_action of truncate
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "*DatabaseName*"."table_name" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-01403: no data found
ORA-04088: error during execution of trigger '*DatabaseName*.****'

 

Solution

change parameter = table_exists_action=TRUNCATE  to table_exists_action=REPLACE

No comments:

Post a Comment

web stats