Export/Import

1. What is the Oracle Data Pump utility? Oracle Data Pump is a utility introduced in Oracle 10g for efficiently moving data and metadata between databases. It is an enhancement of the original export (exp) and import (imp) utilities.

2. Data Pump Vs export/import utilities (exp/imp)? Data Pump provides a more flexible and high-performance infrastructure compared to the older exp/imp utilities. It supports parallelism, enables fine-grained object selection, and offers better job management capabilities.

3. Explain the basic syntax for exporting a full database using Oracle Data Pump.

The basic syntax for exporting a full database using Data Pump is:

expdp SYSTEM/password FULL=Y DIRECTORY=dpump_dir DUMPFILE=full_export.dmp LOGFILE=full_export.log

4. What is the purpose of the DIRECTORY parameter in Oracle Data Pump? The DIRECTORY parameter specifies the Oracle directory object where the Data Pump files (dump file, log file) will be written or read from.

5. How do you perform a schema-level export using Oracle Data Pump? To perform a schema-level export, you can use the SCHEMAS parameter. For example:

expdp SYSTEM/password SCHEMAS=hr DIRECTORY=dpump_dir DUMPFILE=hr_schema_export.dmp LOGFILE=hr_schema_export.log

6. How do you perform a table-level export using Oracle Data Pump? You can perform a table-level export using the TABLES parameter. For example:

expdp SYSTEM/password TABLES=employees DIRECTORY=dpump_dir DUMPFILE=employees_table_export.dmp LOGFILE=employees_table_export.log

7. What is the purpose of the CONTENT parameter in Oracle Data Pump? The CONTENT parameter specifies the type of Data Pump operation, such as metadata-only (METADATA), data-only (DATA), or both metadata and data (ALL).

8.How do you import a Data Pump dump file using impdp? The basic syntax for importing a Data Pump dump file is:

impdp SYSTEM/password DIRECTORY=dpump_dir DUMPFILE=full_export.dmp LOGFILE=import.log

9.Explain the purpose of the REMAP_SCHEMA parameter in Oracle Data Pump. The REMAP_SCHEMA parameter allows you to import data into a different schema than the one from which it was exported. This is useful when you want to remap the schema during the import process.

10.How can you monitor the progress of a Data Pump job? You can query the "DBA_DATAPUMP_JOBS" view to monitor the status of Data Pump jobs. Additionally, the "STATUS" parameter in the Data Pump job can be used to track the progress of the export or import.

11.Explain the use of Data Pump transportable tablespaces feature. Data Pump allows the export and import of transportable tablespaces, enabling the movement of tablespaces between databases. This feature is useful for efficient data migration and copying large volumes of data between Oracle databases.

12.Can we Split export backup in multiple files?

Yes, We can using below parameter

DUMPFILE=%U.dmp FILESIZE=500K

dumpfile=dp_dir1:exp1%U.dmp, dp_dir2:exp2%U.dmp