Oracle Data pump backup and Recovery library

if the user name of the lead-out library is Tiger, the password is 1 imported to the username is Scott, the password is 1

Backup Library

EXPDP Tiger/[email protected] dumpfile=expdp.dmp directory=dpdata1; Export a expdp.dmp file.

Import Library

Create user

Create user Scott identified by 1; (must be performed)

DP Mode

1. Create a directory

Create directory dpdata1 as ' D:\test\dump '; (do not have to be executed, create a directory once.)

2. 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; (must not be performed)

3.give the Scott user permission to operate in the specified directory, preferably as a system Administrator.

Grant Read,write on directory dpdata1 to Scott; (must be performed)

Grant DBA to Scott; (must be performed)

4, guide the storage

IMPDP Scott/[email protected] dumpfile=expdp.dmp directory=dpdata1 Remap_schema=tiger:scott

Note: The directory address created above is d:\test\dump , so be sure to put the expdp.dmp file in this directory when importing.

Oracle Data pump backup and Recovery library