CNDBA社区
1.在导入时候报错
[oracle@node01] /oradata/backup $impdp system/password@xxxxx:1521/xxx directory=ORADATA dumpfile=xxxx.dump logfile=IERS_20230330111.out
Import: Release 19.0.0.0.0 - Production on Thu Mar 30 17:02:50 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Master table "SYSTEM"."SYS_IMPORT_FULL_13" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_13": system/********@xxxxx:1521/xx directory=ORADATA dumpfile=xxxx.dump logfile=IERS_20230330111.out
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PREPARE_DATA_IMP [71]
TABLE_DATA:"xxx"."FABBPM2IERSDEV000000681"
ORA-01403: no data found
2.解决方案:
To avoid the issue use any of below alternatives:
1. Upgrade to at least 20c.
- OR -
2. Apply interim Patch 29450761, if available for your platform and Oracle version.
To check for conflicting patches, please use the MOS Patch Planner Tool
Please refer to
Note 1317012.1 - How To Use MOS Patch Planner To Check And Request The Conflict Patches?
If no patch exists for your version, please contact Oracle Support for a backport request.
- OR -
3. Import using the CONTENT=DATA_ONLY parameter.
3.MOS地址:
Doc ID 2472847.1
版权声明：本文为博主原创文章，未经博主允许不得转载。
oracle
