DataPump Export (EXPDP) ORA-nnnnn Errors (Doc ID 1941688.1)

To Bottom

Modified:

24-Jul-2019

Type:

HOWTO

In this Document

Applies to:

Oracle Database - Standard Edition - Version 10.1.0.2 and later
Oracle Database - Personal Edition - Version 10.1.0.2 and later
Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Goal

The document contains a collection of ORA-nnnnn errors raised during the DataPump export (EXPDP). Please follow the indicated documents to solve the problem and obtain more detailed information about the raised error.

Solution

ORA-1

Note 783396.1 DataPump Export (EXPDP) Fails With Errors ORA-31693 ORA-1
Note 420517.1 DataPump Export With PARALLEL And CONTENT=DATA_ONLY Receives Errors ORA-31693 ORA-1
Note 1341414.1 DataPump Export (EXPDP) Raises ORA-1 On WRI$_ALERT_THRESHOLD When Performing Full Export
Note 1482734.1 Datapump Export Fails And Produces A Huge Log With Errors ORA-31693, ORA-39068, ORA-00001

ORA-904

Note 1448992.1 Data Pump Export reports ORA-39126 / ORA-00904 in KUPW$WORKER.FETCH_XML_OBJECTS
Note 1266939.1 EXPDP Raises ORA-904 "M_LOG$$" When Exporting Materialized View Using NETWORK_LINK
Note 457261.1 DataPump Export (EXPDP) Fails With Errors ORA-39125 ORA-904 ORA-6512 SYS.DBMS_SYS_ERROR

ORA-942

Note 1089767.1 DataPump Export (EXPDP) Fails With Error ORA-942 When Specifying A Query In INCLUDE Clause
Note 806043.1 DataPump Export Or Import (EXPDP/IMPDP) Fails With Errors ORA-31626 ORA-942
Note 1371613.1 DataPump Export (EXPDP) Reports ORA-942 Even If Table Exists
Note 2465993.1 DataPump Master Process Failure Due To ORA-00942
Note 2341607.1 ORA-39006, ORA-39065 and ORA-00942: table or view does not exist When Starting DataPump in 12.2

ORA-1031

Note 1676411.1 EXPDP - ORA-31693 ORA-01031 (Insufficient Privileges) On Some Tables When Exporting from 12cR1
Note 1200303.1 DataPump Export (EXPDP) Raises Errors ORA-31693 ORA-1031 When Exporting Some Tables
Note 789566.1 DataPump Export (EXPDP) Fails With Errors ORA-31693 ORA-1031 When Exporting Table SYSMAN.MGMT_NOTIFY_QTABLE
Note 1102434.1 Full DataPump Export (EXPDP) Fails With Errors ORA-39125 ORA-4045 ORA-1031 On XDB.XDB_PI_TRIG
Note 414996.1 Getting ORA-39127 ORA-1031 Error With DataPump Export (EXPDP)
Note 436106.1 Ora-01031: Insufficient Privileges, When Using The Flashback_time Option with EXPDP/IMPDP Network_link
Note 1145309.1 DataPump Export (EXPDP) Of Datavault Enabled Database Fails With Errors ORA-39097 ORA-1031
Note 1228413.1 DataPump Export (EXPDP) Fails With Errors ORA-39127 SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA ORA-1031

ORA-1403

Note 1469407.1 Schema-level DataPump Export (EXPDP) With CONTENT=METADATA_ONLY Fails With Errors ORA-39126 ORA-1403
Note 1907233.1 expdp generates ORA-39127, ORA-01403 during export of Spatial indexes
Note 1917945.1 EXPDP Fails With ORA-31693 ORA-06502 ORA-01403

ORA-1426

Note 1970141.1 DataPump Export (EXPDP) Fails With ORA-1426 When Dealing With Redact Policies
Note 1952875.1 Export Fails on Tables with Columns Using Data Redaction

ORA-1427

Note 1331721.1 Expdp Returns Ora-1427 when dealing with IOT tables
Note 1065259.1 DataPump Export (expdp) Fails With ORA-1427 On Tables With Object Grants On Nested Tables Columns
Note 1909855.1 DataPump Export (EXPDP) Errors ORA-39126 ORA-1427 Returns More Than One Row When Exporting Materialized Views
Note 1118596.1 DataPump Export (EXPDP) Fails With ORA-1427 When Using A XMLTYPE Column With Object Grants
Note 1064840.1 DataPump Export (expdp) Returns ORA-1427 When Partitioned IOTs With Same Name Exist in More Than One Schema
Note 1988428.1 SuperCluster: EXPDP failing with error ORA-39126, ORA-1427 when exporting types

ORA-1466

Note 1902481.1 EXPDP - How to Solve "ORA-01466: unable to read data - table definition has changed"
Note 1150573.1 Error ORA-1466 Reported By DataPump Export (EXPDP) When Using FLASHBACK_SCN While A Privilege Is Granted
Note 1165825.1 DataPump Export (EXPDP) Terminates Due To ORA-1466 When Using FLASHBACK_TIME
Note 1183703.1 DataPump Export (EXPDP) Fails With Errors ORA-31693 ORA-1466 When Started From DBMS_SCHEDULER
Note 1905612.1 EXPDP - ORA-31693 ORA-01466 (table Definition Has Changed) On SYSMAN.EM_SYSAVAIL_COMP_TARGETS

ORA-1502

Note 2280126.1 - DataPump Job (EXPDP Or IMPDP) Fails Due To ORA-39080 ORA-01502 Index Is In Unusable State

ORA-1555

Note 1086414.1 DataPump Export (EXPDP) For A Large Table Fails With Error ORA-1555
Note 1579437.1 Troubleshooting ORA-01555/ORA-01628/ORA-30036 During Export and Import
Note 1580790.1 Troubleshooting ORA-01555 - Snapshot Too Old: Rollback Segment Number "String" With Name "String" Too Small
Note 1268663.1 ORA-1555 ORA-8180 During DataPump Export (expdp) With Parameter FLASHBACK_TIME

ORA-1591

Note 2081894.1 Data Pump Export Fails with Errors ORA-02354 and ORA-01591
Note 1908869.1 Datapump Export (Expdp) Fails With ORA-31693, ORA-29913, ORA-01591 Due To Pending Distributed Transactions

ORA-1690

Note 1911968.1 Data Pump Export (expdp) aborts with "ORA-01690: sort area size too small"
Note 1358890.1 DataPump Export (EXPDP) Fails With Errors ORA-39126 and ORA-1690 After Applying Patchset 11.2.0.2

ORA-1950

Note 1531789.1 DataPump Export (EXPDP) Fails With Errors ORA-39126 ORA-06512 ORA-1950
Note 454849.1 ORA-1950 Or ORA-1536 During Full Or Schema Database Export
Note 1633698.1 Datapump Export Fails with ORA-1950: "no privileges on tablespace"

ORA-4021

Note 452289.1 Data Pump Export Of One Schema Crashes With Error ORA-39125 And ORA-04021

ORA-4030

Note 1368462.1 DataPump Export (EXPDP) Terminates With Error ORA-4030
Note 453385.1 Data Pump Export With Long SCHEMAS or INCLUDE Parameters Crashes With Ora-04030

ORA-4031

Note 1066911.1 DataPump Export (EXPDP) Fails With Error ORA-4031 For 1207992352 Bytes On 10.2.0.3
Note 1318528.1 DataPump Export (EXPDP) Fails With Errors UDE-31623 ORA-4031
Note 457724.1 DataPump Export (EXPDP) Fails With Error ORA-4031 ("streams pool", ...)
Note 846537.1 DataPump Export (EXPDP) Fails With Errors ORA-31626 ORA-31637 ORA-39080 ORA-4031 ("Streams Pool"..."Fixed Allocation")

ORA-4063

Note 1620162.1 DataPump Export Or Import Fails With ORA-04063: Package Body "SYS.KUPW$WORKER" Has Errors
Note 1642070.1 EXPDP Fails With ORA-39127 ORA-04063 WMSYS.LTADM
Note 726637.1 Traditional Export (EXP) and DataPump (expdp) Fail With ORA-4063: Package Body SYS.DBMS_AW_EXP Has Errors
Note 1526443.1 Data Pump Export (expdp) = ORA-39126 ORA-39127 ORA-4063 (on XDB.DBMS_XDBUTIL_INT & XDB.DBMS_XDBZ0) ORA-6508 / RESOURCE_VIEW Query = ORA-4063
Note 799625.1 ORA-31626 ORA-4063 Package Body DBMS_INTERNAL_LOGSTDBY Has Errors During DataPump Export (EXPDP)
Note 742018.1 Errors ORA-39125 ORA-4063 On View SYS.KU$_CLUSTER_VIEW With DataPump Export (EXPDP)
Note 1556207.1 DataPump Export (EXPDP) Fails With Error ORA-39127 ORA-04063 package body "EXFSYS.DBMS_EXPFIL_EXP" has errors
Note 562988.1 DataPump Export (EXPDP) Fails With Errors ORA-39125 ORA-4063 After Applying Patch 6116131
Note 1903510.1 EXPDP/IMPDP - ORA-04063 (view "SYS.KU$_RADM_FPTM_VIEW" Has Errors) On Full Export / Import
Note 2114343.1 EXPDP/IMPDP - ORA-04063 (package body "SYS.DBMS_STREAMS_DATAPUMP_UTIL" Has Errors) on Full DataPump Job

ORA-6502

Note 1327004.1 - DataPump Jobs Fails With Errors ORA-31626 ORA-31638 ORA-39077 ORA-6502
Note 1451262.1 DataPump Export (EXPDP) Errors Out ORA-39097 ORA-39065 ORA-6502
Note 1358039.1 Data Pump Export (expdp) terminates due to ORA-6502 when using a large Table List
Note 1174662.1 DataPump Export (EXPDP) Fails With Errors ORA-39127 ORA-6502 ORA-6512 In SYS.DBMS_SCHED_MAIN_EXPORT
Note 1666764.1 expdp generates ORA-39127, ORA-20000, ORA-06502 when exporting Text indexes
Note 730668.1 DataPump Export (EXPDP) Fails With Errors ORA-31626 ORA-31637 ORA-6512 ORA-39080 ORA-20299 ORA-6502
Note 1682053.1 Grantee names longer than 28 characters causes ORA-39127, ORA-06502 errors in EXPDP
Note 1585451.1 Expdp Job Fails With ORA-39126/ORA-06502
Note 825033.1 EXPDP fails with ORA-39006 & ORA-06502 'character to number conversion error'
Note 1549641.1 DataPump Export (EXPDP) Fails With Error ORA-39126 ORA-06502 ORA-06512 NULL index table key value
Note 1917945.1 EXPDP Fails With ORA-31693 ORA-06502 ORA-01403
Note 2061532.1 DataPump Export (EXPDP) Fails Due To ORA-39126 And ORA-6502 When Unloading Java Objects
Note 2020412.1 Datapump Export (EXPDP) Fails With ORA-6502 For Selective Data From Table
Note 2130206.1 ORA-6502 Reported For DBMS_SERVER_ALERT_EXPORT.SYSTEM_INFO_EXP When Running DataPump Export

ORA-12838

Note 1558708.1 - ORA-39126 and ORA-12838: cannot read/modify an object after modifying it in parallel from Datapump Export
Note 2163108.1 - DataPump Job Is Failing With ORA-39126 And ORA-12838

ORA-12899

Note 2051535.1 ORA-12899 During Expdp With VERSION parameter In 12.1.0.2

ORA-19505

Note 1597395.1 DataPump Export (EXPDP) Fails With Errors ORA-31693 ORA-31617 ORA-19505 ORA-27037 In a RAC Environment

ORA-19510

Note 1927751.1 When Attempting To Perform Data Pump Export, Getting ORA-19510 ORA-27039 'Additional information: 4' Errors

ORA-22923

Note 1930202.1 EXPDP - ORA-22923 (amount Of Data Specified In Streaming LOB Write Is 0) On The Export of TABLE_STATISTICS

ORA-24033

Note 2063761.1 ORA-24033 Reported Randomly in RAC When Running A DataPump Job

ORA-24795

Note 1638321.1 EXPDP - ORA-24795 (Illegal ROLLBACK Attempt Made) ORA-02354 ORA-01891 On 10.2.0.4 Expdp Job

ORA-25306

Note 948624.1 DataPump Export (EXPDP) Fails With Errors ORA-39079 ORA-25306 On One Node In A RAC Environment
Note 1283214.1 DataPump Export (EXPDP) Fails With Errors ORA-39065 ORA-39079 ORA-06512 ORA-25306 ORA-39097

ORA-27054

Note 1518979.1 DataPump Export (EXPDP) Fails With Errors ORA-39001 ORA-39000 ORA-31641 ORA-27054 ORA-27037 When The Dump File Is On NFS Mount Point
Note 785389.1 DataPump Export (EXPDP) Fails with Error ORA-27054 on HP 11.23
Note 2039397.1 Expdp To NFS Server Share From AIX Hangs Due to Incompatible "-vers"

ORA-27086

Note 1187014.1 RMAN and/or Datapump Export Backup fails with ORA-27086 on NFS / NAS
Note 1939261.1 How to Resolve ORA-39001 ORA-39000 ORA-31641 ORA-27038 ORA-27086 Errors with Datapump Export on NFS/NAS Mount Points

ORA-29283

Note 790163.1 How To Resolve The Errors ORA-39002 ORA-39070 ORA-29283 ORA-6512 When DataPump Export Fails
Note 858401.1 DataPump Export (EXPDP) To A Windows Mapped Network Drive Returns Errors ORA-39002 ORA-39070 ORA-29283 ORA-6512
Note 1305166.1 Errors ORA-39002, ORA-39070, ORA-29283, ORA-6512 Using DataPump Export (EXPDP) or Import (IMPDP)
Note 1350672.1 Expdp Generates ORA-39070 ORA-29283 when DIRECTORY is on DBFS
Note 1605571.1 Errors ORA-39002 ORA-39070 ORA-29283 With 12c Pluggable Database DataPump Export

ORA-31623

Note 1936319.1 Expdp Throws ORA-31623 When Using LOGTIME Parameter
Note 754401.1 Errors ORA-31623 And ORA-600 [kwqbgqc: bad state] During DataPump Export Or Import
Note 308388.1 Error ORA-31623 When Submitting A DataPump Export Job
<Note > DataPump Export (EXPDP) Fails With Errors ORA-31623 ORA-6512 If Parameter _FIX_CONTROL='6167716:OFF' Has Been Set
Note 1579091.1 DataPump Job Fails With Error ORA-31623 A Job Is Not Attached To This Session Via The Specified Handle
Note 1907256.1 How to resolve the Data Pump error ORA-31623 (a job is not attached to this session via the specified handle) ?

ORA-31626

Note 2197898.1 DataPump Jobs Suddenly Starts To Fail With ORA-31626: Job Does Not Exist

ORA-31633

Note 2226152.1 DataPump Job Fails To Start Due to ORA-31633 And ORA-06502

ORA-31642

Note 825680.1 DataPump Export Utility Fails With Errors ORA-39125 ORA-31642 PLS-201 on Package SYS.DBMS_CDC_EXPDP
Note 304449.1 Database Data Pump Export fails with PLS-00201 identifier DMSYS.DBMS_MODEL_EXP must be declared
Note 1243504.1 Expdp Fails With PLS-00201: Identifier 'Dmsys.Dbms_dm_model
Note 1328829.1 EXPDP: PLS-201 identifier 'SYS.DBMS_CUBE_EXP' must be declared
Note 1564521.1 Datapump Export Fails with ORA-39126 ORA-31642 ORA-06512 ORA-06550 PLS-00201 ORA-06550 Errors
Note 1998072.1 EXPDP - ORA-39127 ORA-04063 ORA-06508 (could Not Find SYS.DBMS_CUBE_EXP) ORA-06512

ORA-31655

Note 2089246.1 ORA-39166 or ORA-31655 on Datapump Export With Content=DATA_ONLY
Note 751071.1 DataPump Export Tablespace With Data Causes ORA-31655 No Data Or Metadata Objects Selected For Job
Note 2020410.1 ORA-39165, ORA-39168, ORA-31655 Invoking Datapump Export with Metadata Filters (INCLUDE/ EXCLUDE) and Search Operators (IN/ LIKE)

ORA-39095

Note 433391.1 Parallel Export Fails With Error ORA-39095 If There Are Less Specified Files Than Slaves
Note 559692.1 DataPump Export (EXPDP) Error ORA-39095 Dump File Space Has Been Exhausted
Note 1071931.1 DataPump Export Fails With Error ORA-39095
Note 1665905.1 EXPDP Fails Inconsistently With ORA-39095 When Combining With Compression Tools In Scheduled OS script

ORA-39113

Note 2100177.1 ORA-39113 When Running A DataPump Job Through NETWORK_LINK

ORA-39127

Note 1353491.1 - DataPump Export (EXPDP) Errors ORA-39127 SYS.DBMS_CUBE_EXP.INSTANCE_EXTENDED_INFO_EXP ORA-44002 After Upgrade

ORA-39165

Note 553402.1 DataPump Export (EXPDP) Fails With Error ORA-39165: Schema SYS Was Not Found

ORA-39166

Note 1640392.1 EXPDP - ORA-39166 (Object Was Not Found) When Trying To Export The Data From A View

ORA-39181

Note 422480.1 ORA-39181:Only Partial Table Data Exported Due To Fine Grain Access Control

ORA-39816

Note 2036259.1 With Data Redaction, expdp fails with "ORA-39816: Direct Path Unload of tables with encrypted column(<table_name>.<column_name>) is not allowed."

ORA-60019

Note 2206255.1 DataPump Export (EXPDP) Fails With ORA-31626 ORA-31633 ORA-60019

相关阅读:
11_listview入门
10_上午回顾&数据库事务
09_sqlite两种api比较
08_通过谷歌封装的api操作数据库update&query
微软宣布下一代集成开发环境 — Visual Studio 2019
微软宣布下一代集成开发环境 — Visual Studio 2019
Chrome 调试技巧
Chrome 调试技巧
Chrome 调试技巧
程序员最喜欢说的十句话，看看你最喜欢说哪句？

原文地址：https://www.cnblogs.com/yaoyangding/p/12504020.html