删除用户:
drop user zhwg cascade;
删除表空间:
DROP TABLESPACE ZHWG INCLUDING CONTENTS AND DATAFILES;
创建表空间:
create tablespace MONITORTBSPACE
logging
datafile 'D:\Program_Files\oracle\product\10.2.0\oradata\orcl\MONITORTBSPACE.dbf'
size 50m
autoextend on next 50m maxsize 5480m
extent management local;
创建用户,并指定表空间:
create user zhwg identified by zhwg
default tablespace MONITORTBSPACE;
给用户授予权限:
grant connect,resource to zhwg;
导入数据:
imp system/admin@orcl file=C:\Users\yan\Desktop\ZHWG_DB\data1.dmp fromuser=monitoruser touser=zhwg ignore=y statistics=none
imp system/admin@orcl file=C:\Users\yan\Desktop\ZHWG_DB\data2.dmp fromuser=monitoruser touser=zhwg ignore=y statistics=none
导出数据:
exp monitoruser/eism@eism file=C:\Users\yan\Desktop\ZHWG_DB\data.dmp owner=username1