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