[email protected]:1531/hrdb as sysdba
--创建目录
create or replace directory exp_dir as '/oradata/dumpdir';
--授权
grant read,write on directory exp_dir to hradm;
--查询
select * from dba_directories;
--创建tbscpc表空间
create tablespace tbshr
datafile '/oradata/edw/hrdb/hrdb-001.dbf'
size 2G
autoextend on
next 64m maxsize 20G
segment space management auto
extent management local;
alter tablespace tbshr
add datafile '/oradata/edw/hrdb/hrdb-002.dbf' size 2G
autoextend on
next 50m maxsize 20G;
alter tablespace tbshr
add datafile '/oradata/edw/hrdb/hrdb-003.dbf' size 2G
autoextend on
next 50m maxsize 20G;
--给cpcadm和admin授权,并修改默认表空间
grant dba,resource to hradm;
select * from dba_users where username='HRADM';
alter user hradm default tablespace tbshr;
alter database default tablespace tbshr;
create user admin identified by admin;
grant connect,dba to admin;
--使用impdp导入hrdb数据
impdp [email protected] directory=exp_dir dumpfile=hr20180401004000.DMP remap_tablespace=tbs_hr:tbshr remap_schema=hr:hradm schemas=hr table_exists_action=replace transform=segment_attributes:n
remap_tablespace=tbs_hr:tbshr 原来表空间:新的表空间
remap_schema=hr:hradm 原来的schema:现在的schema
transform=segment_attributes:n 去掉表空间和存储子句,加上这个参数后,remap_tablesapce参数就会失效,就会倒进用户默认的表空间,
原文:http://blog.51cto.com/peenboo/2103826