数据文件用法
增加数据文件
alter tablespace FACIALLOB add datafile 'E:\ORALDATA\FACIALLOB01.DBF' size 10240M;
改变大小
alter database datafile 'E:\ORALDATA\FACIALLOB01.DBF' resize 2048M;
设置自动扩展
alter database datafile 'E:\ORALDATA\FACIALLOB01.DBF' autoextend on next 10M maxsize 30G;
总结
alter tablespace FACIALLOB add datafile 'E:\ORALDATA\FACIALLOB01.DBF' size 5M autoextend on next 5M maxsize 50G;
为表空间增加回滚段
create rollback segment rollback_name
tablespace FACIALLOB
storage( initial 3k next 3k optimal 3k minextents 3 maxextents 3)
alter rollback segment rollback_name online;
alter tablespace FACIALLOB add datafile 'E:\ORALDATA\FACIALLOB01.DBF' size 10240M;
改变大小
alter database datafile 'E:\ORALDATA\FACIALLOB01.DBF' resize 2048M;
设置自动扩展
alter database datafile 'E:\ORALDATA\FACIALLOB01.DBF' autoextend on next 10M maxsize 30G;
总结
alter tablespace FACIALLOB add datafile 'E:\ORALDATA\FACIALLOB01.DBF' size 5M autoextend on next 5M maxsize 50G;
为表空间增加回滚段
create rollback segment rollback_name
tablespace FACIALLOB
storage( initial 3k next 3k optimal 3k minextents 3 maxextents 3)
alter rollback segment rollback_name online;