LINUX下采用impdp方式导入数据库:
1.创建表空间,用户,赋权限,创建目录
create tablespace TS_DEFAULT datafile '/oradata/pay/pay.dbf' size 1g;create user pay identified by cosco default tablespace TS_DEFAULT;
grant connect,resource,unlimited tablespace to pay;
create directory mydir as '/oradata/pay';
2.由于本人用root创建的pay目录,所以得先切换到root用户下赋权限
chown oracle:dba /oradata/paychown oracle:dba /oradata/pay/pay.dmp
3.linux下输入
impdp system/password remap_tablespace=TS_COSCO_DEFAULT:TS_COSCO_DEFAULT directory=mydir remap_schema=pay:pay dumpfile=mydir:pay.dmp logfile=mydir:pay.log