We ran across the following error while running a metadata-only export data pump on an 11.2.0.4 database:
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [PROCA CT_SCHEMA:"SYSMAN"] ORA-01690: sort area size too small ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPW$WORKER", line 9715 ----- PL/SQL Call Stack ----- object line object handle number name 0x11d4c2bf0 21979 package body SYS.KUPW$WORKER 0x11d4c2bf0 9742 package body SYS.KUPW$WORKER 0x11d4c2bf0 11838 package body SYS.KUPW$WORKER 0x11d4c2bf0 2808 package body SYS.KUPW$WORKER 0x11d4c2bf0 10422 package body SYS.KUPW$WORKER 0x11d4c2bf0 1824 package body SYS.KUPW$WORKER 0x11df95480 2 anonymous block Job "SYS"."SYS_EXPORT_FULL_21" stopped due to fatal error at Wed Dec 23 18:13:11 2020 elapsed 0 00:05:34
According the Oracle Support Doc ID 1358890.1, this is a known bug that occurs after applying patch set 11.2.0.2. There are some solutions in Doc ID 1358890.1 including upgrading to 12.1, applying patch set 11.2.0.4 or an interim patch set. Another solution is to
update sys.metaview$ set properties = properties + 1024 where viewname = 'KU$_PROCACT_SYS_VIEW';
We tried the update option, including increasing the size up to 4096. However, this did not resolve the error. After some trial and error, we were able to complete the export with the below command:
expdp \'/ as sysdba \' directory=exp_dir dumpfile=rpt.dmp exclude=statistics exclude=schema:\"IN \(\'SYSMAN\',\'SYSTEM\',\'VRRPT1NE\',\'SYS\'\)\" full=y content=metadata_only