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