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 »
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 »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 »In today’s post, we will cover How to Use Flashback during Export. [crayon-648402174dc29930941886/] [crayon-648402174dc2e305959901/] This value is found as follows; [crayon-648402174dc30887530012/]
Read More »In today’s article, we will be learning to use Parallel during Export in data pump. [crayon-648402174de0c115803647/] Here; %u: Let the names of the Dump Files …
Read More »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-648402174dfcc061696837/]
Read More »Compression parameter in data pump is COMPRESSION. COMPRESSION parameter can be used with ALL, DATA_ONLY, METADATA_ONLY and NONE values. [crayon-648402174e18b071557654/]
Read More »The number of parallels is usually determined by the number of CPUs. For example, below are 2 parallel data pump exports. [crayon-648402174e318597812624/] We can also …
Read More »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-648402174e4e1707817969/]
Read More »Today I will be explaining How to Make Copy of Schema in Oracle Data Pump. 1. We take an export backup of the schema to …
Read More »It may be necessary to temporarily stop a running export/import process for some reason. In this case, we may need to attach it first. 1. …
Read More »