#oracle datapump tutorial

[ocptechnology]

Estimate Required Disk Space for Export Using Estimate_only

Estimate Required Disk Space for Export Using 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. Check segment size using below command. SQL> select…

[ocptechnology]

How To Export Tablespaces Using Expdp Data Pump Utility?

How To Export Tablespaces Using Expdp Data Pump Utility?

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 expdp utility which is also called logical backup of the tablespace in the Oracle database. The export…