Oracle 11g Data Pump technical details (EXPDP IMPDP)

Use data pump technology for logical backups
Logical Backup Overview

A logical backup is the process of creating a logical copy of a database object and depositing it into a binary dump file. Essentially, logical backup and recovery is actually the import and export of database fact data.

Export:

The export is a logical backup of the database, essentially reading a database record and writing the recordset to a file (usually a DMP extension), where the export of these records is independent of the physical location

Import:

Import is the logical recovery of the database, essentially reading the exported binary dump file and restoring it to the database.

Import/export using Data pump technology

Data PUMP is a technology that transfers data between databases or between databases and the operating system at high speeds. The data pump tool runs on the server, and the database administrator needs to specify the database directory to hold the dumped data.

Connecting to an Oracle database

Create an Action directory

Grant user permission to manipulate the Dump_dir directory

Export data using the EXPDP command (you can export by table, export by user mode, export by table space and full-scale), import data using the IMPDP command (you can import by table, import by user mode, export by table space, and full-Library import).

Import and Export databases using command-line-based data pump technology.

Sql>col Directory_name for A20

Sql>col Director_path for A60

Sql>col OWNER for A8

Create a test user Tom and authorize

Export EMP and Dept tables under the Scott user

[Email protected]~]$ expdp scott/oracle directory=dump_dir dumpfile=scotttab.dmp tables=emp,dept

Connect to the Scott user to remove the EMP table under the Scott user

Import an EMP table

[Email protected]~]$ impdp scott/oracle directory=dump_dir dumpfile=scotttab.dmp tables=emp

The EMP table has been imported successfully.

Import the Dept table and EMP table under the exported Scott user to Tom User

[Email protected]~]$ impdp system/oracle11g Directory=dump_dir dumpfile=scotttab.dmptables=scott.emp,scott.dept Remap_schema=scott:tom

View the results of the import, using the Tom user connection

Export Table Space

Create a table AA on the XX table space and insert a record for the table

Export Table Space

Delete data files while table space xx is deleted

The AA table is gone.

Import Table Space

Before you import a tablespace, you need to create a table space of XX

Import Table Space xx

Verify that the AA table recovers back.

Export Full Library

[Email protected]]$ expdp system/oracle11g directory=dump_dir dumpfile=full.dmp full=y

Import Full Library

[Email protected]]$ impdp system/oracle11g directory=dump_dir dumpfile=full.dmp full=y

If you are interested in this, please scan the QR code below for free for more details

Oracle 11g Data Pump technical details (EXPDP IMPDP)