How to import dmp files with impdp

How to import dmp files through impdp: first open cmd; then create a table space, create a user, and grant permissions; then log in to the ToolBox user; and finally write the import impdp statement.

impdp method of importing dmp files:

1. Use

directly under cmd No need to log in to oracle. Only dmp files exported by expdp can be imported.

2. When exporting expdp, you need to create a DIRECTORY

What table space is exported, and what table space is required for importing. Which users are exported will also be imported.

3. If it does not exist, create a new one.

The database dmp file of the TOOLBOX user is exported from the server expdp and needs to be imported into the local development environment.

The local oracle environment is brand new (windows environment).

4. Create table space

create tablespace TOOLBOX
logging
datafile 'C:\oraclexe\app\oracle\oradata\XE\TOOLBOX.dbf'size 50mautoextend onnext 32m maxsize unlimitedextent management local;

5. Create user and grant permissions

create user TOOLBOX identified by 123456;
alter user TOOLBOX default tablespace TOOLBOX;
grant CREATE ANY DIRECTORY,create session,create table,create view,unlimited tablespace to TOOLBOX;

6. Log in to ToolBox user

Create DIRECTORYCREATE OR REPLACE DIRECTORY DMPDIR AS 'c:\';

7. Write the import impdp statement

impdp toolbox/123456 DIRECTORY=DMPDIRDUMPFILE=hz_toolbox_20160613.dmp full=y

Related learning recommendations: java basic tutorial

The above is the detailed content of How to import dmp files with impdp. For more information, please follow other related articles on the PHP Chinese website!