Oracle创建表空间-创建用户

1.创建表空间：
create tablespace root datafile 'D:\Oracle\dataSpace\root.dbf' size 50m autoextend on;

2.创建用户:
CREATE USER root IDENTIFIED BY root DEFAULT TABLESPACE root TEMPORARY TABLESPACE temp;

3.赋予权限：
GRANT CONNECT TO root;
GRANT RESOURCE TO root;
GRANT dba TO root;

4.

create directory dump_dir as 'D:\dmp\LY725.DMP';
grant read,write on directory dump_dir to root;
impdp root/root@orcl DIRECTORY=dump_dir DUMPFILE=LY725.DMP SCHEMAS=FRAMEWORK version=11; 【cmd操作界面操作，注意文件空间名一致（标红）】

5.导入dmp文件

imp amc/amc file=D:\XXXX\XXXX\XXXXXX.DMP full=y ignore=y 
imp root/root@ file='LY725.DMP' full=y ignore=y

imp amc/amc file=D:\XXXX\XXXX\XXXXXX.DMP full=y ignore=y 
imp 需要导入的用户/密码@ file='文件地址（具体到名字后缀）' full=y (常用)【cmd操作界面操作】