Category: Data Pump

INTRODUCTION Oracle Data Pump is the replacement for the original Export and Import utilities.Available starting in Oracle Database 10g, Oracle DaRead More…

DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabledDBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabledDBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabledDBMS_AW_EXP: SYS.Read More…

This is expected behavior for a schema level import.Object privileges for which the import schema is the grantee will not be imported in a schema levRead More…

Data pump is block mode and exp is a byte mode. So, block mode is always faster than the byte mode ORACLE Export (exp) vs Datapump (expdp) ORACRead More…

In this article I will show you how to perform an Export but creating the file in a remote server. Sometimes we have to deal with these kind of “chalRead More…

Data pump is really a handy tool. It has many options allowing you to try different ways and provides flexibility. In this entry, I’ll use some of thRead More…

Configure a shell script, to take export backup of table daily at 3 PM and send the log to stake holders. Script: ( EXP_TAB_cmprss.sh) !/bin/baRead More…

Data Pump IMPDP TABLE_EXISTS_ACTION = APPEND, REPLACE, [SKIP] and TRUNCATEIn conventional import utility (IMP) we have ignore =y option which will igRead More…

Many a times, we may observe that datapump is running slow even after using PARALLEL option. But, we donít know that there is a method to calculate Read More…

Lets suppose we have a dumpfile and we have no clue from which database or atleast which version of database it is exported. (assume we donít have aRead More…