CREATE TABLESPACE "TEST"
DATAFILE 'TEST.DBF' SIZE 2048 AUTOEXTEND ON NEXT 2048;
创建用户及指定表空间/索引表空间
CREATE USER "TEST"
IDENTIFIED BY "admin1234"
DEFAULT TABLESPACE "TS_DAT_TEST"
DEFAULT INDEX TABLESPACE "TS_IDX_TEST";
赋予权限
GRANT "PUBLIC","RESOURCE","VTI","SOI" TO "TEST";
取消用户限制
ALTER USER "TEST" LIMIT
FAILED_LOGIN_ATTEMPS UNLIMITED,
PASSWORD_LOCK_TIME UNLIMITED,
PASSWORD_GRACE_TIME UNLIMITED;
查看用户会话当前的模式名:
SQL> SELECT TYPE$,NAME FROM SYSOBJECTS WHERE ID=CURRENT_SCHID;
SQL> SELECT SF_GET_SCHEMA_NAME_BY_ID(CURRENT_SCHID);
或者:
SQL> select sys_context('USERENV','CURRENT_SCHEMA');
指定当前模式:
SQL> alter session set current_schema=TEST2;
或者
SQL> set schema TEST2;
#默认模式名与用户名相同,且用户登录之后不指定当前模式或者操作的对象前不加模式名“模式名.对象名”,默认是操作默认模式下的对象;