Oracle DataPump Quick Start
INTRODUCTION Oracle Data Pump is the replacement for the original Export and Import utilities.Available starting in Oracle Database 10g, Oracle DaRead More…
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…