增加表空间

sql 代码

alter tablespace EMSINDX add datafile'/ems/oracle7/oradata/EMS/emsv3_emsindx03.dbf' size 200M;
2006.02.16
alter tablespace EMSINDX add datafile'/ems/oracle7/oradata/EMS/emsv3_emsindx07.dbf' size500M;

alter tablespace EMS_INDEX add datafile'/ems/oracle7/oradata/EMS/ems_index03.dbf' size 200M;

alter tablespace USERS add datafile'/ems/oracle7/oradata/EMS/ems_users04.dbf' size 300M;

2005.12.31 USERS 87%
alter tablespace USERS add datafile'/ems/oracle7/oradata/EMS/ems_users08.dbf' size 800M;

alter tablespace ZHW add datafile'/oracle/oradata/yz/zhw02.dbf' size 800M;

分享到：

查询表空间几个脚本 | oracle定期表分析

• 2007-10-23 21:00
• 浏览 883
• 评论(0)
• 查看更多