EXPDP

COMPRESSION in datapump oracle

COMPRESSION parameter is used with EXPDP, to compress the generated dump file. NOTE – For using compression parameter with datapump, we need to have Oracle advance compression license.   CO...

REUSE_DUMPFILES parameter in EXPDP

If we try to export a dumpfile with the name, which is already present in that directory. then we will get error like ORA-27038: created file already exists ORA-39001: invalid argument value ORA-39000...

SAMPLE parameter in EXPDP to export subset of data

Let’s say we have a very big table, and for testing purpose, we need only a subset of data i.e to let’s say 10 percent of data from that table, then SAMPLE parameter can be used in EXPDP. ...

ESTIMATE REQUIRED DISK SPACE FOR EXPORT USING estimate_only

ESTIMATE_ONLY parameter can be used in EXPDP command, to estimate the disk space required for the export job, without doing the actual export. So when we are not sure what will be the export dump size...

FLASHBACK parameter in DATAPUMP(EXPDP)

We can use the flashback parameter ( FLASHBACK_SCN or FLASHBACK_TIMESTAMP) in expdp to take a consistent backup of the table as of a specific point in time. Flashback method depends upon undo data. So...

CONTENT parameter in datapump

CONTENT parameter is used in expdp or impdp, to load/unload data only, metadata only or both. CONTENT Specifies data to unload. Valid keyword values are: [ALL], DATA_ONLY and METADATA_ONLY.   CON...

Query clause in oracle datapump expdp

             QUERY clause can be used in expdp or impdp to export/import subset of the data or data with specific conditions. DEMO: Export dump of a table from emp_tab WHERE created > sysdat...

ENCRYPTION in expdp impdp

We can enable password based encryption for expdp dumps, by using different encryption related parameters in expdp/impdp command. ENCRYPTION RELATED PARAMETERS: ENCRYPTION Encrypt part or all of a dum...

Cluster parameter in oracle RAC database

In a RAC database, if you are taking export with the parallel option and the datapump directory is not shared between the nodes, then export might fail with below error Because the remote node is unab...

Datapump export to ASM diskgroup (EXPDP)

It is tvery common to export dump file to the standard file system(Mount points). However, we can export the dump files to ASM diskgroup also. In this article, we will show the steps for this . DEMO 1...