In today’s article, I will give information about the Data Export and Export processes. In order for us to export with the expdp tool: We …

In today’s article, I will be explaining how to do Partition Table Export AND Import in 3 steps. 1. We export the PARTITIONED TABLE, which …

We can import an object from the database to a different database and a different tablespace with a different schema. 1. First, let’s get this …

Instead of rewriting the commands each time, we can use a parameter file to export/Import with Data Pump. 1. First we create the parameter file. …

In today’s article, we will learn how we can create a Oracle Remap Table in three steps. 1. The table is exported from the first …

In some cases, it may be desirable to make a copy of an existing schema or to transfer a schema from one database to another. …

In today’s post, we will cover How to Use Flashback during Export. [crayon-6740129951ca5294062579/] [crayon-6740129951ca9678189786/] This value is found as follows; [crayon-6740129951cab773518433/]  

In today’s article, we will be learning to use Parallel during Export in data pump. [crayon-6740129951e67032958565/] Here; %u: Let the names of the Dump Files …

We use ENCRYPTION as Encryption parameter in Oracle Data Pump. We can use the ENCRYPTION parameter with the values ALL, DATA_ONLY, METADATA_ONLY and ENCRYPTED_COLUMNS_ONLY. [crayon-674012995200b158668584/]

Compression parameter in data pump is COMPRESSION. COMPRESSION parameter can be used with ALL, DATA_ONLY, METADATA_ONLY and NONE values. [crayon-6740129952171461778338/]