Skip to content

Make DBA Life Easy

  • Home
  • Blog
  • Investment
  • About
  • Contact
  • Disclaimer
  • Subscribe
Make DBA Life Easy

Day: September 8, 2021

ORA-39126 ORA-22990 from Data Pump

The following errors appear from ExaCC Oracle 12.1.0.2 data pump impdp:

...
..
.
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid, metadata_io, option_tag FROM "IMP_USER"."SYS_IMPORT_SCHEMA_01" WHERE  process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order]
ORA-22990: LOB locators cannot span transactions

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x4d745c700     27118  package body SYS.KUPW$WORKER
0x4d745c700     11286  package body SYS.KUPW$WORKER
0x4d745c700      4745  package body SYS.KUPW$WORKER
0x4d745c700     12063  package body SYS.KUPW$WORKER
0x4d745c700      2081  package body SYS.KUPW$WORKER
0x4dd854618         2  anonymous block

In procedure CREATE_MSG
KUPV$FT.MESSAGE_TEXT
KUPV$FT.MESSAGE_TEXT
In procedure SEND_MSG. Fatal=0
KUPC$QUEUE_INT.SEND
KUPC$QUEUE_INT.SEND
Processing object type SCHEMA_EXPORT/TABLE/TABLE
KUPF$FILE.CLOSE_CONTEXT
KUPF$FILE.CLOSE_CONTEXT
In procedure DETERMINE_FATAL_ERROR with ORA-22990: LOB locators cannot span transactions
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "HR"."EMPLOYEE"              751.6 KB    3371 rows
. . imported "HR"."SALARY"                1.412 MB    2992 rows
...
..
.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe
Log in
Author dbalifeeasyPosted on September 8, 2021Categories DataPump, Premium ContentTags ORA-22990: LOB locators cannot span transactions, ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA, SELECT process_orderLeave a comment on ORA-39126 ORA-22990 from Data Pump

Google Translate

SEARCH

Calendar

September 2021
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
27282930  
« Aug   Oct »

Archives

Blog Stats

  • 1,151,648 hits

Categories

  • AWS (9)
  • GoldenGate (6)
    • Config (2)
    • Docs (1)
    • Exam & Interview Q/A (1)
    • Install and Upgrade (2)
  • Linux (26)
  • MySQL (4)
    • Install and Upgrade (3)
    • Startup and Shutdown (1)
  • Oracle (535)
    • 12c/13c/18c/19c/20x New Features (9)
    • ADR (2)
    • ASM (27)
    • AWR (5)
    • CDB/PDB (18)
    • CHM (14)
    • Client (10)
    • CMU (2)
    • Configuration (25)
    • Corruptions (3)
    • DataGuard (52)
    • DataPump (17)
    • dbms_scheduler (6)
    • Exadata & ExaCC (10)
    • FLASHBACK (2)
    • GI and RAC (109)
    • Globalization (1)
    • Install Upgrade and Patches (64)
    • JAVA (2)
    • Materialized View (7)
    • OEM( Oracle Enterprise Manager) (79)
      • OEM 12c (8)
      • OEM13c (72)
    • ORA- ERRORS (55)
    • oracle advanced compression (4)
    • ORMB (13)
    • Partitioning (12)
    • Performance Tunning (28)
    • RMAN Restore and Recovery (20)
    • Security (10)
    • SQL Net (16)
    • SQL Scripts For DBA (25)
    • TDE (6)
    • TOOLS( AHF TFA ORAchk EXAchk ) (6)
    • TTS (1)
    • User Privileges and Roles (16)
  • PostgreSQL (31)
    • Client (4)
    • Extension (6)
    • Install and Upgrade (8)
    • Migration (4)
    • Objects (4)
    • Performance Tuning (1)
    • Privileges (1)
    • SQL Scripts for DBA (4)
    • Vacuum (4)
  • Premium Content (228)
  • SQL Server (26)
    • Always On (3)
    • Backup and Restore (2)
    • Client (1)
    • Install Patch and Upgrade (4)
    • Security (2)
    • Space (2)
    • SQL Scripts for DBA (6)
    • SSMA (4)
    • Versions (2)
  • VirtualBox (14)
  • Windows (15)

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com
  • Home
  • Blog
  • Investment
  • About
  • Contact
  • Disclaimer
  • Subscribe
Make DBA Life Easy Blog at WordPress.com.
  • Follow Following
    • Make DBA Life Easy
    • Join 47 other followers
    • Already have a WordPress.com account? Log in now.
    • Make DBA Life Easy
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar