How to export public database objects with Oracle Data Pump
Neither original Oracle Export (exp) utility nor Data Pump (expdp) can capture related public Oracle database objects during schema(s) export. During the schema(s) copy or refresh you have to transfer them to the target database manually BEFORE the import to avoid related import errors. These public objects are: Read more »
Oracle Data Pump (expdp) schema export fails with ORA-01801
Platform
Oracle Database Server 10gR2 (10.2.0.5)
Problem
Data Pump (expdp) schema export fails on Oracle 10gR2 with following Oracle error:
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [TABLE_STATISTICS]
Read more »
ORA-01801: date format is too long for internal buffer
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6313
Oracle Export and Import utilities tips
In spite of the fact that Oracle recommends using the new Data Pump tools (expdp/impdp) available as of Oracle Database 10g, many developers and DBAs still use the original Oracle Export and Import (exp/imp) utilities. Below I will quickly summarize some useful Export and Import tips. Read more »