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 …
Read More »Onur ARDAHANLI
Using Parameter Files
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. …
Read More »Oracle Remap Table
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 …
Read More »Remap Schema
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. …
Read More »Oracle Export Flashback_Time
In today’s post, we will cover How to Use Flashback during Export. [crayon-662b3f9cec4d4723304410/] [crayon-662b3f9cec4da428162777/] This value is found as follows; [crayon-662b3f9cec4db863074142/]
Read More »Parallel Export
In today’s article, we will be learning to use Parallel during Export in data pump. [crayon-662b3f9cec6d3137943567/] Here; %u: Let the names of the Dump Files …
Read More »Oracle Data Pump Encryption
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-662b3f9cec8ce036021399/]
Read More »Data Pump Compression
Compression parameter in data pump is COMPRESSION. COMPRESSION parameter can be used with ALL, DATA_ONLY, METADATA_ONLY and NONE values. [crayon-662b3f9ceca9a885812150/]
Read More »Data Pump Export Parallel
The number of parallels is usually determined by the number of CPUs. For example, below are 2 parallel data pump exports. [crayon-662b3f9cecc2f466641939/] We can also …
Read More »Dump File Reuse
We can use the existing dump file with the same name only once. If we want to use it continuously, reuse_dumpfiles=y is used. [crayon-662b3f9cecdc2531767451/]
Read More »