--创建临时表空间
create temporary tablespace data_temp
tempfile 'D:\oracle\oraudata\data_temp.dbf'
size 2000m
autoextend on
next 500m
extent management local;
--创建数据包空间
create tablespace data_data
logging
datafile 'D:\oracle\oraudata\data_data.dbf'
size 2000m
autoextend on
next 500m
extent management local;
--创建用户并指定表空间
create user dbadmin identified by dbpass
default tablespace data_data
temporary tablespace data_temp;
--删除用户命令
--drop user dbadmin cascade
--给用户授予权限
grant connect,resource to dbadmin
--撤权
--revoke connect,resource from dbadmin[/color]
create temporary tablespace data_temp
tempfile 'D:\oracle\oraudata\data_temp.dbf'
size 2000m
autoextend on
next 500m
extent management local;
--创建数据包空间
create tablespace data_data
logging
datafile 'D:\oracle\oraudata\data_data.dbf'
size 2000m
autoextend on
next 500m
extent management local;
--创建用户并指定表空间
create user dbadmin identified by dbpass
default tablespace data_data
temporary tablespace data_temp;
--删除用户命令
--drop user dbadmin cascade
--给用户授予权限
grant connect,resource to dbadmin
--撤权
--revoke connect,resource from dbadmin[/color]