oracle创建用户

create user test identified by "test";
grant dba to test;
grant unlimited tablespace to test;
grant create any table to test;

创建表空间
create tablespace  SM10001 
logging  datafile 'd:\oracle\test_data01.dbf'   size 32m 
autoextend on next 32m maxsize 2048m  extent(宽度) management(管理、处理) local;

赋表空间给用户
alter user smchannel default tablespace SM10001

 

--以下两句解决无法动态创建函数索引问题
如:
create index I_USER on T_USER (SUBSTR(USER_NAME,1,2))
alter system set query_rewrite_enabled = true;
grant query rewrite to test;