04.txt

Oracle+Database+10g基础教程[第二版]PPT和示例代码.rar

create tablespace mydb_tbs
datafile '/ora100/oracle/mydb/mydb_tbs_01.dbf' size 100m;

create rollback segment tbs_rs01 tablespace mydb_tbs
storage (initial 100k next 100k minextents 10 optimal 1000k);


create tablespace my_tbs
datafile 'ora100/oracle/mydb/mydb_tbs_001.dbf' size 100m;


alter database add logfile group 4
('c:\oracle\oradata\mydb\mydb_logfile_group4_1_a.log',
 'd:\oracle\oradata\mydb\mydb_logfile_group4_1_b.log') size 100m;