Oracle database backup EXPDP/IMPDP Export Import command

Things to be aware of when using EXPDP and IMPDP:

Exp and IMP are client tool programs that can be used either on the client or on the server side.

EXPDP and IMPDP are server-side utilities that can only be used on the Oracle server and not on the client side.

IMP is only available for exp exported files, not for EXPDP export files, IMPDP only for EXPDP exported files, not for exp export files.

To create a logical directory, the command does not create a real directory in the operating system, preferably created by an administrator such as system.

New file path D:\test\dump in the D-disk, and then run in SQL

Create directory dpdata1 as ' D:\test\dump ';

Second, view the Management Manager directory (and see if the operating system exists, because Oracle does not care if the directory exists, and if it does not exist, an error occurs)

SELECT * from Dba_directories;

Third, export

C:\USERS\ADMINISTRATOR>EXPDP Scott/[email protected] Schemas=scott directory=dpdata1 dumpfile=scott_bak.dmp

Iv. Import

Create a new user test

C:\USERS\ADMINISTRATOR>IMPDP Scott/[email protected] remap_schema=scott:test dumpfile=scott_bak.dmp logfile= Scott_bak.log directory=dpdata1

Oracle database backup EXPDP/IMPDP Export Import command