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