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

最新推荐文章于 2024-10-16 15:56:38 发布

pliuxibk

最新推荐文章于 2024-10-16 15:56:38 发布

阅读量114

点赞数

分类专栏：数据库文章标签： oracle

本文链接：https://blog.csdn.net/pliuxibk/article/details/110625563

版权

数据库专栏收录该内容

3 篇文章 0 订阅

订阅专栏

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;