We can monitor the status of an export/import operation running in the background by attaching it with the ATTACH parameter. For this, we first need …
Read More »
We can monitor the status of an export/import operation running in the background by attaching it with the ATTACH parameter. For this, we first need …
Read More »Instead of constantly writing our command and parameters for export/import operations, we can create a file containing our parameters and use this file in export/import …
Read More »With the SQLFILE parameter, it provides us with the sql statements that import operations run. [crayon-6484c98028545042730104/] Afterwards, you can see which commands are available by …
Read More »In today’s article we will learn how to use the Estimate_only parameter for Dump File Size Estimation. [crayon-6484c980286e6817176327/]
Read More »While the Export or Import process is in progress, we can switch to the interactive command line mode with Ctrl+C from the keyboard. We can …
Read More »In today’s article, I will tell you how to Kill Data Pump Jobs in 3 steps. 1. First, Data Pump Jobs are listed. [crayon-6484c980288b7364790414/] 2. …
Read More »In today’s article, we will be learning DataPump Commands. 1. İmport: [crayon-6484c9802909f192695698/] 2. Export: [crayon-6484c980290a6989460552/] 3. Dump file size estimation: [crayon-6484c980290a8302158716/] 4. Remap schema: [crayon-6484c980290a9294409280/] …
Read More »We can create a new “Database Directory” without using existing database directories in the database. [crayon-6484c98029349589266425/] We can view the directories that exist in the …
Read More »In today’s article, we will be learning about Oracle Data Pump Architecture. It has 4 important components. -expdp (export data pump) -impdp (import data pump) …
Read More »In today’s article we will be learning how to Performing SwitchOver. 1. First, we move the logs in our live database. (PRIMARY_1) [crayon-6484c98029d96311327527/] (PRIMARY_2) [crayon-6484c98029d9c442669222/] …
Read More »