ORA-39006: internal error-ORA-39065: unexpected master process exception in DISPATCH-ORA-01552: cannot use system rollback segment for non-system tablespace ‘TEMP’ – ORA-39097: Data Pump job encountered unexpected error -1552

Cause:

During import of object using network link , due to dumpfile specification error is triggered

[oracle@orcl19x ~]$ impdp \'/ as sysdba\' directory=exp dumpfile=NL_TEST.dmp logfile=NL_TEST.log tables=TEST.TABX table_exists_action=replace network_link=EXDBX metrics=YES

Import: Release 12.1.0.2.0 - Production on Mon Aug 16 16:10:17 2021

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

ORA-39097: Data Pump job encountered unexpected error -1552

Workaround:

Remove dumpfile parameter during network link data transfer because data is sent via TNS network pipeline from source to destination and dumpfile is not required.

[oracle@orcl19x ~]$ impdp \'/ as sysdba\' directory=exp logfile=NL_TEST.log tables=TEST.TABX table_exists_action=replace network_link=EXDBX metrics=YES

Import: Release 12.1.0.2.0 - Production on Mon Aug 16 16:25:20 2021

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "SYS"."SYS_IMPORT_TABLE_01":  "/******** AS SYSDBA" directory=exp logfile=NL_TEST.log tables=TEST.TABX table_exists_action=replace network_link=EXDBX metrics=YES
Startup took 4 seconds
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
     Estimated 1 TABLE_DATA objects in 3 seconds
Total estimation using BLOCKS method: 95.75 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
     Completed 1 TABLE objects in 11 seconds
. . imported "TEST"."TABX"                              1048576 rows in 1276 seconds

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s