建立序列:
CREATE SEQUENCE SEQ_SYS_SERVICELOG
INCREMENT BY 1 -- 每次加几个
START WITH 1 -- 从1开始计数
NOMAXVALUE -- 不设置最大值
NOCYCLE -- 一直累加,不循环
CACHE 20;
建立表空间:
create tablespace celldef datafile 'e:/oradata/celldef.dbf' size 1000m;
删除表空间:
drop tablespace tablespace_name including contents and datafiles;
建立用户:
CREATE USER esb IDENTIFIED BY esb
DEFAULT TABLESPACE esb
TEMPORARY TABLESPACE TEMP;
GRANT CONNECT, RESOURCE,dba TO esb;
删除用户:
DROP USER esb CASCADE;
创建ESB_INDEX索引表空间:
CREATE TABLESPACE ESB_index DATAFILE 'E:/ORA_DATA/SIMIS/ESB_INDEX.ora' SIZE 200M REUSE
AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT STORAGE(INITIAL 320K
NEXT 320K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0);
删除索引空间:
DROP TABLESPACE ESB_INDEX INCLUDING CONTENTS;
修改相应的名称后执行即可。