创建表空间、用户、分配权限

创建表空间

CREATE TABLESPACE TS_HX_ZSJ DATAFILE   '/u01/app/oracle/oradata/HXNS/datafile/ts_hx_zsj_001.dbf'

SIZE 500M AUTOEXTEND ON NEXT 50M MAXSIZE   UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE IDX_HX_ZSJ DATAFILE   '/u01/app/oracle/oradata/HXFX/datafile/idx_hx_zsj_001.dbf'

SIZE 100M AUTOEXTEND ON NEXT 50M MAXSIZE   UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SEGMENT SPACE MANAGEMENT AUTO;

创建用户

CREATE USER HX_ZSJ

  IDENTIFIED BY css

  DEFAULT TABLESPACE TS_HX_ZSJ

  QUOTA UNLIMITED ON TS_HX_ZSJ

  PROFILE DEFAULT

  ACCOUNT LOCK;

 

分配权限

 GRANT CONNECT TO HX_ZSJ;

  GRANT RESOURCE TO HX_ZSJ;

  ALTER USER HX_ZSJ DEFAULT ROLE ALL;