oracle 创建表空间与用户

-- 创建表空间mytest

CREATE TABLESPACE mytest

DATAFILE '/u01/app/oracle/oradata/healthybox/mytest01.dbf' size 200M
EXTENT MANAGEMENT local;

-- 创建用户tester
CREATE USER tester IDENTIFIED BY tester
DEFAULT TABLESPACE mytest;

--分配以下权限

grant connect,dba to tester;

grant exp_full_database,imp_full_database,resource,create any sequence to tester;

grant create any trigger,create any view,create table,drop any view to tester;

grant exp_full_database,imp_full_database,resource,create any sequence to tester;

-- 创建自增字段

create sequence StudentID_sequence --创建 sequence 名为 UserID_sequence
increment by 1  -- 每次自增1
start with 1  --从1 开始自增
nomaxvalue --没有最大值
nocycle --不循环

insert into student (id, stdname, stdnum)  values( StudentID_sequence.nextval  , 'ruby',22);

--也可以写在触发器中，来实现