oracle 创建序列 表空间 用户

--创建序列
CREATE SEQUENCE increase_sequence
INCREMENT BY 1 -- 每次加几个
START WITH 1 -- 从1开始计数
MAXVALUE 9999999999
MINVALUE 1
--NOMAXVALUE -- 不设置最大值
NOCYCLE -- 一直累加，不循环
NOCACHE -- 不建缓冲区
select increase_sequence.nextval from dual;--查询序列下一值

select increase_sequence.currval from dual;--查询序列当前值

drop sequence increase_sequence;--删除序列
触发器
create or replace trigger bbs_topic_autoNo

　　before insert on bbs_topic----(sysrole为表名)

　　for each row----触发每一行

　　begin

　　select bbs_topic_sequences.nextval into :new.topicid from dual;

　　end;

创建表空间
create tablespace hcrm
datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\hcrm.dbf' size 200M
autoextend on next 20M maxsize unlimited logging
extent management local autoallocate
segment space management auto
commit;
穿件用户
-- Create the user
create user HCRM
identified by ""
default tablespace HCRM
temporary tablespace TEMP
profile DEFAULT
quota unlimited on hcrm;
-- Grant/Revoke role privileges
grant dba to HCRM with admin option;
-- Grant/Revoke system privileges
grant administer any sql tuning set to HCRM with admin option;
grant unlimited tablespace to HCRM with admin option;