1、首先,我们可以先建立自己的一个用户表空间,创建表空间的格式如下:
create tablespace eas(表空间的名字)
datafile 'D:\eas\eas.dbf' (这边可以写成oracle的某个路径下)
size 50m (初始大小)
autoextend on;(自动扩展)
create tablespace KINGDEE01 datafile 'D:\eas\KINGDEE01.dbf' size 50m autoextend on;
2、接下来,我们可以创建一个自己的用户,创建格式如下:
CREATE USER KINGDEE01
IDENTIFIED BY 123
DEFAULT TABLESPACE KINGDEE01
TEMPORARY TABLESPACE temp;--(临时表空间就写temp即可)
profile DEFAULT;
3、然后,我们需要给自己的用户赋予权限来管理自己的表空间
with admin option --再授权权限非级联
with grant option --再授权权限级联
grant connect to KINGDEE01 with admin option ;
GRANT RESOURCE TO KINGDEE01 with admin option;
grant dba to KINGDEE01with admin option;
grant unlimited tablespace to KINGDEE01with admin option;
grant create session to KINGDEE01;
4、创建dump文件夹存放DMP文件(本条语句并不会在E盘eas文件夹下新建dump文件夹,需要用户手动创建)
create directory eas as 'E:\eas\dump';
5、把DMP文件存放到dump文件夹下,打开命令行窗口,执行如下操作
impdp system/1234 directory=EAS dumpfile=exp_kingdee01_20180831.dmp schemas=KINGDEE01 logfile=eas.log table_exists_action=replace