COMPRESSION in datapump oracle
COMPRESSION parameter is used with EXPDP, to compress the generated dum...
EXPDP
REUSE_DUMPFILES parameter in EXPDP
If we try to export a dumpfile with the name, which is already pres...
SAMPLE parameter in EXPDP to export subset of data
Let’s say we have a very big table, and for testing...
ESTIMATE REQUIRED DISK SPACE FOR EXPORT USING estimate_only
ESTIMATE_ONLY parameter can be used in EXPD...
FLASHBACK parameter in DATAPUMP(EXPDP)
We can use the flashback parameter ( FLASHBACK_SCN or FLASHBACK_T...
CONTENT parameter in datapump
CONTENT parameter is used in expdp or impdp, to load/unload data only, m...
Query clause in oracle datapump expdp
QUERY clause can be used in expdp or impdp to export/im...
ENCRYPTION in expdp impdp
We can enable password based encryption for expdp dumps, by using different ...
Cluster parameter in oracle RAC database
In a RAC database, if you are taking export with the parallel...
Datapump export to ASM diskgroup (EXPDP)
It is tvery common to export dump file to the standard file sys...