创建用户:tstuser
表空间 :tstdata
tstind
1 查看表空间路径
select * from dba_data_files;
2. 创建表空间
create tablespace TSTDATAdatafile '/u02/oradata/db/tstdata_001.dbf' size 1024m autoextend offextent management localsegment space management auto;
alter tablespace TSTDATAadd datafile '/u02/oradata/db/tstdata_002.dbf' size 2048m autoextend off,'/u02/oradata/db/tstdata_003.dbf' size 4096m autoextend off,'/u02/oradata/db/tstdata_004.dbf' size 4096m autoextend off;
create tablespace TSTINDdatafile '/u02/oradata/db/tstind_001.dbf' size 1024m autoextend offextent management localsegment space management auto;
alter tablespace TSTINDadd datafile '/u02/oradata/db/tstind_002.dbf' size 2048m autoextend off,'/u02/oradata/db/tstind_003.dbf' size 4096m autoextend off,'/u02/oradata/db/tstind_004.dbf' size 4096m autoextend off;
3. 创建用户及指定表空间
create user tstdbusr identified by 123456 default tablespace tstdata ;
4. 增加数据库可连接
grant connect,resource to tstdbusr;
5. 增加视图权限
grant create any view to tstdbusr;