oracle中把库表导入本机操作步骤

1、用system创建个表空间和用户 ：
create tablespace GZJY_DATA_TSlogging datafile 'G:\app\houxiaonan\oradata\wcdd.dbf’size 50mautoextend onnext 50m maxsize 20480mextent management local;
2.–创建用户
drop user dljy_er2 cascade;-- Create the user create user dljy_er2 identified by dljy1234 default tablespace GZJY_DATA_TS temporary tablespace TEMP profile DEFAULT;-- Grant/Revoke role privileges grant connect to dljy_er2;grant resource to dljy_er2; grant all privileges to dljy_er2;
3、把服务oracl数据文件 放到 111测试服务器 D:\oracle\dump文件中
4、改下D:\ora\imp.bat中的数据文件名 直接运行
drop user dljy_er2 cascade;
– Create the user
create user dljy_er2
identified by dljy1234
default tablespace GZJY_DATA_TS
temporary tablespace TEMP
profile DEFAULT;
– Grant/Revoke role privileges
grant connect to dljy_er2;
grant resource to dljy_er2;
grant read,write on directory dump_dir to dljy_er2;
revoke unlimited tablespace from dljy_er2;
alter user dljy_er2 quota 0 on USERS;
alter user dljy_er2 quota unlimited on GZJY_PART_DATA_TS;
alter user dljy_er2 quota unlimited on GZJY_PART_INDX_TS;
alter user dljy_er2 quota unlimited on GZJY_DATA_TS;
alter user dljy_er2 quota unlimited on GZJY_INDX_TS;
grant read,write on directory dump_dir to dljy_er2;grant create any view to dljy_er2;