创建oracle的tablespace

1.本机的directory

select * from dba_directories

2.建立表空间

CREATE TABLESPACE SID DATAFILE 'D:\oracle\oradata\sid\SIDDBS.DBF'

SIZE                                  1000M

AUTOEXTEND ON MAXSIZE                4000M

EXTENT MANAGEMENT LOCAL UNIFORM SIZE  64K;

 

CREATE TABLESPACE SID_INDX DATAFILE 'D:\oracle\oradata\sid\SIDINDEXES.DBF'

SIZE                                  100M

AUTOEXTEND ON MAXSIZE                1000M

EXTENT MANAGEMENT LOCAL UNIFORM SIZE  64K;

 

CREATE USER "用户名"  PROFILE "DEFAULT" IDENTIFIED BY "用户名"

    DEFAULT

    TABLESPACE "表空间" TEMPORARY

    TABLESPACE "TEMP" ACCOUNT UNLOCK;

GRANT "CONNECT" TO "用户名";

GRANT "DBA" TO "用户名";

exit;

3.把exp dp方式汇出的dmp文件，拷贝到directory目录下

4.拔掉网线

5.执行imp dp语句 

 Impdp 用户名/密码 dumpfile= 名字.dmp directory= DATA_PUMP_DIR schemas=schemas名字 content=All