每个数据文件20G,共计200G
createtablespacestgdatafile‘h :/ora _ TBS/stg 01.DBF‘size 20 gextentmanagementlocalsegmentspacemanagementagementautauto;
altertablespacestgadddatafile‘h :/ora _ TBS/stg 02.DBF‘size 20g;
altertablespacestgadddatafile‘h :/ora _ TBS/stg 03.DBF‘size 20g;
altertablespacestgadddatafile‘h :/ora _ TBS/stg 04.DBF‘size 20g;
altertablespacestgadddatafile‘h :/ora _ TBS/stg 05.DBF‘size 20g;
altertablespacestgadddatafile‘h :/ora _ TBS/stg 06.DBF‘size 20g;
altertablespacestgadddatafile‘h :/ora _ TBS/stg 07.DBF‘size 20g;
altertablespacestgadddatafile‘h :/ora _ TBS/stg 08.DBF‘size 20g;
altertablespacestgadddatafile‘h :/ora _ TBS/stg 09.DBF‘size 20g;
altertablespacestgadddatafile‘h :/ora _ TBS/stg 10.DBF‘size 20g;
createuserstgidentifiedbystgdefaulttablespacestgtemporarytablespacetemp;
授权连接,资源到stg;
grant dba to stg;
-表空间的用户验证
alteruserstgquotaunlimitedonstg;
授权创建any table to stg;
授权更新any table to stg;
grant select any table to stg;
授权插入any table to stg;
grant drop any table to stg;
授权删除any table to stg;
grant create any index to stg;
Grop any index to stg;
grant comment any table to stg;
grant execute any procedure to stg;
- createorreplacedirectoryoraxrpdslas‘/home/Oracle/oraxrpdsl‘;
- -授权写入,readondirectoryoraxrpdsltojmbsuser;
grantselectondba _ jobs _ runningtostg;
grant select on dba_jobs to stg;
grant select on v_$session to stg;
grant select on v_$process to stg;
grant execute on dbms_lock to stg;
grant execute on dbms_job to stg;
授权Alter session to stg;
授权Alter系统至stg;
grantselectondba _ data _ filestostg;
gantselectondba _ free _ spacet ostg;
授权创建any view to stg;
grant drop any view to stg;