建表空间
create tablespace THAMS
logging
datafile \'D:\test2\TOOLBOX.dbf\'
size 700m
autoextend on
next 32m maxsize unlimited
extent management local;
建目录
create directory dump_testamber2 as \'/home/oracle/amber2dmp\';
建用户
create user abc identified by 123456;
赋权限
grant connect,resource,dba to abc;
grant dba,resource,unlimited tablespace to CWBASEYJY;
grant read,write on directory dump_testamber2 to abc;
将表空间赋给用户
alter user MYUSER default tablespace MYTABLESPACE;
将目录赋给用户
grant read,write on directory DIRDP to MYUSER;
impdp thams/thams DIRECTORY=zgdir DUMPFILE=expdat.dmp full=y encryption_password=123456