本文介绍了Oracle数据库中使用SQL语句进行表空间删除、用户创建及权限分配，并通过exp和imp工具进行数据导出与导入的操作流程。
drop tablespace jnzh including contents and datafiles cascade constraints;
drop user user_jnzh cascade;
create tablespace jnzh datafile 'E:\oracle\jnzh' size 4000M autoextend on next 100M;
create user user_jnzh identified by pwd default tablespace jnzh;
grant connect,resource,create view to user_jnzh;
exp userid=USER_HYGLFW_JN0312/pwd@lyzh file=F:\USER_HYGLFW_JN0312.dmp
imp userid=USER_HYGLFW_JN0312/pwd@zzy file=F:\USER_HYGLFW_JN0312.dmp full=y
drop user user_jnzh cascade;
create tablespace jnzh datafile 'E:\oracle\jnzh' size 4000M autoextend on next 100M;
create user user_jnzh identified by pwd default tablespace jnzh;
grant connect,resource,create view to user_jnzh;
exp userid=USER_HYGLFW_JN0312/pwd@lyzh file=F:\USER_HYGLFW_JN0312.dmp
imp userid=USER_HYGLFW_JN0312/pwd@zzy file=F:\USER_HYGLFW_JN0312.dmp full=y
扫一扫
1652
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
