创建表空间
CREATE SMALLFILE TABLESPACE "TS_QL"
DATAFILE 'D:\ORACLE\ORADATA\ORCL\TS_QL01.DBF'
SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
创建临时表空间
CREATE SMALLFILE TEMPORARY TABLESPACE "TS_QL_TEMP"
TEMPFILE 'D:\ORACLE\ORADATA\ORCL\TS_QL_TEMP01.DBF'
SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
创建用户
CREATE USER "QL" PROFILE "DEFAULT" IDENTIFIED BY "*******"
DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK
GRANT UNLIMITED TABLESPACE TO "QL"
GRANT "CONNECT" TO "QL"
GRANT "RESOURCE" TO "QL"
执行的时候可以把双引号都去了。
用控制台创建
服务器--表空间--创建
创建表空间1
创建表空间2
创建用户1
创建用户2
创建用户3
oracle 查看用户的表空间,表空间路径,角色,权限
http://happyqing.iteye.com/blog/2087743