windows给oracle导入dmp文件

建表空间

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