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

posted @ 2020-02-06 10:18  黑魔法os  阅读(2650)  评论(0编辑  收藏  举报