ORACLE导入dmp文件命令

命令行登录SQL管理员
sqlplus sys/admin as sysdba
切换数据库用户
conn 用户名/密码
导入dmp文件
001、创建表空间
CREATE TABLESPACE jianguoqiche02 LOGGING DATAFILE 'D:\APP\xxx\ORADATA\ORCL\jian02.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M maxsize unlimited EXTENT MANAGEMENT LOCAL;
002、创建临时表空间
create temporary tablespace jianguoqiche02_temp tempfile 'D:\APP\xxxx\ORADATA\ORCL\jian02_tmp.dbf' size 100m autoextend on next 100m maxsize unlimited extent management local;
003、创建用户schema
CREATE USER jian02 IDENTIFIED BY jian02 DEFAULT TABLESPACE jianguoqiche02 TEMPORARY TABLESPACE jian02_temp;
004、用户授权
GRANT CREATE USER,DROP USER,ALTER USER,CREATE ANY VIEW,DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,DBA,CONNECT,RESOURCE,CREATE SESSION TO jian02 ;
005、把dmp文件放入上述查询的目录中
select * from all_directories ;
006、导入命令  cmd 执行。无需登录
impdp jian02/jian02@orcl directory=ORACLE_DMP_DIR dumpfile=exp_jg.dmp REMAP_SCHEMA=bt:jian02 remap_tablespace=BTDATA:jian02