1: 创建用户directory环境
create or replace directory test_dir as ‘/home/oracle/dp’;
2: 创建表空间
create tablespace try logging datafile ‘/home/try.dbf’ size 1G autoextend on next 50m maxsize 2G extent management local;
3: 创建用户
create user try identified by try default tablespace try;
4:赋予权限
grant connect,resource to try;
grant read,write on directory test_dir to try;
5:导入数据:
impdp system directory=test_dir dumpfile=’/home/oracle/dump/try.dmp’