创建Oracle表空间

1.创建临时表空间

  create  temporary  tablespace test_temp
  tempfile 'D:\app\oradata\orcl\test_temp.dbf'
  size 50m
  autoextend on
  next 50m maxsize 2048m
  extent management local;

2.创建数据表空间

create tablespace test_data
logging    
datafile 'D:\app\oradata\orcl\test_data.dbf'
size 50m
autoextend on
next 50m maxsize 2048m
extent management local;

3.创建用户并指定表空间

create user 'username' identified by 'password'
default tablespace test_data
temporary tablespace test_temp;

4.授权给用户

grant connect,resource,dba to 'username';

5.授权给用户

revoke dba from 'username';

6.创建序列

create sequence SCORES_ID
minvalue 1
maxvalue 99999999999999
start with 1000
cache 20;

7.创建索引

--唯一索引
CREATE UNIQUE INDEX INDEXSTUNAME ON 表名(字段名):
--位图索引
CREATE BITMAP INDEX INDEXSTUID ON 表名(字段名);