Datapump impdp failing with ORA-02393 in Autonomous database
(Doc ID 2977686.1)
Last updated on OCTOBER 06, 2023
Applies to:
Autonomous Database Serverless - Version N/A and laterInformation in this document applies to any platform.
Symptoms
Customer was performing Datapump import as admin user which was failing on Autonomous database with ORA-02393 :
Master table "ADMIN"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "ADMIN"."SYS_IMPORT_TABLE_01": ADMIN/********@ADB_high directory=DATA_PUMP_DIR credential=CRED_RAFA2 dumpfile=https://objectstorage.eu-frankfurt-1.oraclecloud.com/n/tenancy_namespace/b/importDWH/o/SADA.dmp CONTENT=DATA_ONLY REMAP_TABLESPACE=RD_DATA:DATA,GB_DATA:DATA,IC2:DATA,USERS:DATA,WP_DATA:DATA TABLES=owner_name.table_name transform=segment_attributes:n transform=dwcs_cvt_iots:y transform=constraint_use_default_index:y exclude=cluster,indextype,db_link logfile=imp_table_name.log
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Warning: Statistics not gathered while loading data for table "owner_name.table_name"
ORA-31693: Table data object "owner_name"."table_name" failed to load/unload and is being skipped due to error:
ORA-02393: exceeded call limit on CPU usage
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_DATA [TABLE_DATA:"owner_name"."table_name"]
UPDATE "ADMIN"."SYS_IMPORT_TABLE_01" SET processing_state = :1, processing_status = :2 WHERE process_order = :3 AND duplicate = 0 AND processing_state = :4 AND processing_status = :5
ORA-02393: exceeded call limit on CPU usage
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |