Home > Java > JavaBase > body text

How to import dmp files with impdp

coldplay.xixi
Release: 2020-10-23 14:07:06
Original
18695 people have browsed it

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.

How to import dmp files with impdp

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;
Copy after login

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;
Copy after login

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
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template