oracle导入数据

首选切换数据库
export ORACLE_SID=<数据库实例id>;

然后sys连接数据库按照以下步骤操作：
1.创建临时表空间
create temporary tablespace TEMP_DB_01 TEMPFILE '/u01/oradata/bj/tablespace/TEMP_DB_01.DBF' size 256M autoextend on next 32M maxsize 2048m extent management local;
2.设置临时表空间为默认表空间
alter DATABASE default temporary tablespace TEMP_DB_01;
3.创建表空间
create tablespace TSP_DB1 logging datafile '/u01/oradata/bj/tablespace/TSP_DB1.DBF' size 3072M autoextend on next 32M maxsize unlimited extent management local;
4.创建用户
create user <user> identified by <pwd> account unlock default tablespace TSP_DB1 TEMPORARY TABLESPACE TEMP_DB_01;
5.授权
grant connect,resource to <user>;
grant dba to <user>;
6.创建目录
create directory imp_dir as '/tmp/importdata';
7.quit后导入数据
impdp <user>/<pwd> directory=imp_dir dumpfile=expdp_db_20170922.dmp logfile=impdp.log table_exists_action=replace;