Oracle表空间-大小设置

来源：互联网发布：php怎么让一组数据相加编辑：程序博客网时间：2024/06/07 09:05

1、到达最大值后自动扩展

SQL> alter database datafile 'C:\orcl1122\disk5\lianxi_index.dbf' autoextend on
2 next 2M;
Database altered

SQL>
SQL> select FILE_NAME   ,AUTOEXTENSIBLE from dba_data_files where file_id=9;
FILE_NAME                                                                        AUTOEXTENSIBLE
-------------------------------------------------------------------------------- --------------
C:\ORCL1122\DISK5\LIANXI_INDEX.DBF                                               YES

2、手工重做数据文件的大小
SQL> alter database datafile 'C:\orcl1122\disk5\lianxi_index.dbf' resize 25M;
Database altered

SQL> select FILE_NAME , BYTES/(1024*1024) MB from dba_data_files where file_id='9';
FILE_NAME                                                                                MB
-------------------------------------------------------------------------------- ----------
C:\ORCL1122\DISK5\LIANXI_INDEX.DBF                                                       25

SQL>
3、添加数据文件增加表空间
SQL> alter tablespace lianxi_index add datafile 'C:\ORCL1122\DISK5\LIANXI_INDEX02.DBF' size 15M;
Tablespace altered
SQL> select FILE_NAME , BYTES/(1024*1024) MB from dba_data_files where file_id>'9';
FILE_NAME                                                                                MB
-------------------------------------------------------------------------------- ----------
C:\ORCL1122\DISK5\LIANXI_INDEX02.DBF                                                     15

阅读全文

0 0