orcale导入dmp文件步骤

**

导入数据库dmp文件步骤

1. cmd 进入window
2. 以管理员登陆oracle
sqlplus as / sysdba
3. 创建用户
CREATE USER test PROFILE DEFAULT IDENTIFIED BY test;
4. 给test用户赋权限 分别执行下面三行语句
GRANT UNLIMITED TABLESPACE TO test
GRANT CONNECT,RESOURCE TO test;
grant dba to test。
5. 创建tempdump 目录，dmp文件的存放位置
CREATE OR REPLACE DIRECTORY tempdump AS ‘F:\dmpdirectory\dmp’;
6. 给dmp文件夹赋权限给test用户
GRANT READ, WRITE ON DIRECTORY tempdump TO test;
7. 退出sql窗口,cmd窗口下执行导入。
impdp root/password directory=tempdump dumpfile=xx.dmp logfile=xx.log
**