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]
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
Read more »

How to make exp utility work on Oracle 11gR2

The fact that Oracle Data Pump does not work from a client installation only still forces many developers and DBAs to work with old Export (exp) and Import (imp) utilities. In spite of Original Export being unsupported  for general use as of Oracle database 11g, in reality it’s still available and can be used. However, there are a few issues with exp utility on Oracle database 11gR2 that have to be fixed before using it. Read more »

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 »

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email