数据泵导入导出数据详细步骤

一 导入数据

1 创建表空间

CREATE TABLESPACE XXX_INDEX01 DATAFILE 'E:\XXX\tablespace\XXX_index01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K; 
CREATE TABLESPACE XXX_DATA01 DATAFILE 'E:\XXX\tablespace\XXX_data01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K; 

2 创建用户

 create user 用户名 identified by "密码" default tablespace XXX_DATA01;

3 授权

grant connect,dba to 用户名 with admin option;