重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 在19c上为表空间增加数据文件 [打印本页]

作者: Inkcup 时间: 2025-5-29 18:00
标题: 在19c上为表空间增加数据文件
环境:
oracle19.26

-- 查看SCHOOL表空间现有的数据文件：
SQL> select * from dba_free_space where tablespace_name = 'SCHOOL';

TABLESPACE_NAME       FILE_ID BLOCK_ID    BYTES    BLOCKS RELATIVE_FNO
-------------------- ---------- ---------- ---------- ---------- ------------
SCHOOL                      9       128  103809024    12672          9

SQL> select * from dba_data_files where tablespace_name = 'SCHOOL';

FILE_NAME             FILE_ID TABLESPACE_NAME          BYTES    BLOCKS STATUS RELATIVE_FNO AUT MAXBYTES  MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_  LOST_WR
-------------------- ---------- -------------------- ---------- ---------- --------- ------------ --- ---------- ---------- ------------ ---------- ----------- ------- -------
/u01/data/school01.d       9 SCHOOL             104857600    12800 AVAILABLE          9 YES 1073741824    131072       12800  103809024    12672 ONLINE  OFF
bf

-- 为SCHOOL表空间增加数据文件：
SQL> ALTER TABLESPACE SCHOOL ADD DATAFILE '/u01/data/school02.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 1G;

Tablespace altered.

SQL> select * from dba_data_files where tablespace_name = 'SCHOOL';

FILE_NAME             FILE_ID TABLESPACE_NAME          BYTES    BLOCKS STATUS RELATIVE_FNO AUT MAXBYTES  MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_ LOST_WR
-------------------- ---------- -------------------- ---------- ---------- --------- ------------ --- ---------- ---------- ------------ ---------- ----------- ------- -------
/u01/data/school01.d       9 SCHOOL             104857600    12800 AVAILABLE          9 YES 1073741824    131072       12800  103809024    12672 ONLINE  OFF
bf

/u01/data/school02.d       10 SCHOOL             104857600    12800 AVAILABLE          10 YES 1073741824    131072       12800  103809024    12672 ONLINE  OFF
bf

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)