ORA-39126 – During Schema Export

Issue:

Schema export form system user failed with below errors.

Estimate in progress using BLOCKS method…
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD [ESTIMATE_PHASE]
ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPW$WORKER”, line 9001

—– PL/SQL Call Stack —–
object line object
handle number name
4069d2ac0 20462 package body SYS.KUPW$WORKER
4069d2ac0 9028 package body SYS.KUPW$WORKER
4069d2ac0 6814 package body SYS.KUPW$WORKER
4069d2ac0 13688 package body SYS.KUPW$WORKER
4069d2ac0 2654 package body SYS.KUPW$WORKER
4069d2ac0 9697 package body SYS.KUPW$WORKER
4069d2ac0 1775 package body SYS.KUPW$WORKER
4053c83e8 2 anonymous block

Solution:

There was a DUAL table created under SYSTEM user having multiple rows.

SQL> select table_name,owner from dba_Tables where table_name=’DUAL’;

TABLE_NAME OWNER
—————————— ——————————
DUAL SYS
DUAL SYSTEM

SQL> select * from dual;

D

X
X
X
X

Dropped the custom dual table created under system and the export worked fine.

drop table system.dual;

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s