Oracle DataPump Performance Tuning


In this article, we are going to learn datapump performance tuning. The Datapump is a tool that helps us to create a database backup. There are a few ways to increase export backup performance listed below: DIRECT=Y PARALLEL=n DIRECT=Y During export backup, if we use direct=y, it’s allowed to skip the SQL evaluation buffer. Though … Read more

Data Pump Export Import Over the Network using network_link

datapump network_link

In this article, we going to learn how to use the network_link parameter in oracle datapump export & import activity step by step. Case: Sometimes we need to move a table or schema from one database to another database but don’t have sufficient disk space on the production server. As you know the dump file … Read more

Export Backup Automation in Oracle On Linux

export backup automation

Hello, friends in this article we are going to learn how to schedule database export backup automatically. Yes, it is possible to export backup automation with a crontab scheduler. How to schedule Export Backup Using shell scripting, we can schedule the export backup as per our convenient time. Using the following steps we can schedule … Read more

Queries to Monitor Expdp Datapump Jobs Status

monitor expdp datapump jobs

How do you monitor Expdp Impdp process? This article is all about monitoring oracle DataPump jobs, checking expdp or impdp jobs status, killing running jobs,troubleshoot hang jobs, etc. Here you will get different queries, which you can use to start, stop, resume, kill and see the status of data pump jobs. So, let’s monitor the … Read more

How to Export Tables using PARFILE STEP BY STEP

Export Tables using PARFILE, Table export also known as the table level export in oracle data pump utility. DBA take table level export using expdp data pump command. Oracle DBA perform export import task as per there requirements. Export backup also called as logical backup. The export backup we can perform as table level, schema … Read more

Estimate Required Disk Space for Export Using Estimate_only

EXPDP Estimate only

In Data Pump EXPDP command use estimate only, to check the estimate the disk space required for the export backup job without performing real export backup. Before creating the export dump it’s better to check dump size using estimate_only. For example we are going to take demo of scott user. EXPDP Estimate only Step 1. … Read more

How To Export Tablespace Using Expdp Data Pump Utility?

How To Export Tablespaces Using Expdp Data Pump Utility

Export Tablespace Using Expdp Hi, In this article we are going to learn how to export tablespaces using expdp data pump utility practically. What is tablespace? A tablespace is a logical unit of storage that is used by the database to store database objects like tables and PL/SQL codes. We can export tablespaces using the … Read more

Check Datapump dump file is corrupted or not

Check Datapump dump file is corrupted or not

Hi, in this article we are going to learn how to check datapump dump file is corrupted or not. Actually, sometimes we face the situation. We take the export backup a long time back and we are not sure the dump file is still valid or not. Sometimes the application team says the dump file … Read more

How to use REMAP_TABLE parameter in impdp utility

remap table

How to Remap table during import? REMAP TABLE/SCHEMA/TABLESPACE parameter, Like you want to import a table from your existing logical backup (export backup), but the table already exists. So in this situation, how to import that table because, so in this case you can import this table with another name using REMAP_TABLE parameter. Import Table with Remap … Read more

How to split the datapump dumpfiles || limit the file size of dumpfile in Datapump

How to split dumpfiles

How to set limit the file size of dumpfile in Datapump? In this article we are going to discuss how to split the datapump dumpfiles, actually, the FILESIZE parameter is used to set limit the dumpfile size. For eg., if you want to limit your dumpfiles to 50m,  you can issue use the below command. Note:  The %u will … Read more

Oracle Data Pump Utility

Oracle Data Pump Utility

Data Pump Utility In this tutorial, we are going to describe the oracle data pump utility step by step. What is Data Pump Utility? Oracle Data Pump is a very fast and high-speed utility. Through the Data Pump utility, we can move data and metadata from one database to another database very fast. Oracle Data … Read more

Oracle Data Pump

Oracle Data Pump

DataPump Hello friends my name is Shripal Singh and in this article, I’m going to show you three topics related to Oracle Data Pump EXPORT & IMPORT, listed below. Oracle Data Pump 10g, 11g, 12c, 18c, 19c Oracle Data Pump is an alternative to the “exp” and “imp” utilities which are used in older Oracle … Read more

Export Backup with Date and Time

Export Backup with Date and Time

Export with Date and Time Hello friends, in this article we are going to discuss how to take export backup with date and time, so follow me step by step. In Oracle, the EXPORT dump file name includes Date and Time. If you are taking export backup using EXP command the use below formats to … Read more