创建表空间
create tablespace TESTDB datafile 'E:\oracle\product\10.2.0\oradata\test\testdb.dbf' size 10240M
autoextend on next 10250M maxsize 10270M
default storage(initial 10M next 1M)
permanent
online
logging;
create tablespace YLBXTEMP datafile 'D:\oracle\product\10.2.0\oradata\ylbx\ylbxtemp.dbf' size 5120M
autoextend on next 7680M maxsize 10240M
default storage(initial 10M next 1M)
permanent
online
logging;
创建用户并指定表空间
create user SYSDATA identified by SYSDATA
default tablespace TESTDB
profile DEFAULT;
create user webuser identified by web
default tablespace ylbx01
temporary tablespace YLBXTEMP
profile DEFAULT;
给用户授予权限
grant dba,connect,resource to SYSDATA;
grant connect to webuser;
导入数据备份文件
imp userid=yjjcdb/yjjcdb file='D:\yjjc.dmp' fromuser=yjjcdb touser=yjjcdb log='D:\import.log'
imp userid=yjjcdb/yjjcdb@igrp_127.0.0.1 file='D:\yjjc.dmp' fromuser=yjjcdb touser=yjjcdb log='D:\import.log'
exp yjjcdb/yjjcdb@igrp_127.0.0.1 file=yjjcdb_20110617.dmp owner=yjjcdb
exp carmot/carmot@igrp_127.0.0.1 file=D:\carmot_20110822_tbmenurolelist.dmp owner=carmot
++
删除表空间
drop tablespace ylbx01 including contents and datafiles;
删除用户名:
drop user jmyb cascade;
drop user SYSDATA cascade;