oracle数据泵导入导出byxiao

-- impdp命令导入
1、cd 进入oracle的bin目录下
-- 登陆管理员账号
sqlplus admin/admin as sysdba

2创建临时表空间
CREATE TEMPORARY TABLESPACE EPMSDEV_TEMP
TEMPFILE 'E:\oraclespace\EPMSDEV_TEMP.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;

2建立表空间
create tablespace EPMSDEV
logging 
datafile 'E:\oraclespace\EPMSDEV.dbf' 
size 32m 
autoextend on 
next 32m maxsize unlimited 
extent management local; 

3、创建用户和授权
create user hn_new identified by hn_new
default tablespace EPMSDEV
temporary tablespace EPMSDEV_TEMP; 

grant connect,resource,dba to hn_new;