Oracle 12cに表領域を拡張する方法

書式
1.SELECT FILE_NAME FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'tablespace_name’
2.ALTER DATABASE DATAFILE 'xxx\USERCFT.DBF’ RESIZE xxM;

操作例
1.表領域のDBFファイルの名称と場所一覧を確認

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SQL> SELECT FILE_NAME FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'USERCFT'
結果
FILE_NAME
D:\ORACLE\ORADATA\CFTDB\USERCFT.DBF
SQL> SELECT FILE_NAME FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'USERCFT' 結果 FILE_NAME D:\ORACLE\ORADATA\CFTDB\USERCFT.DBF
SQL> SELECT FILE_NAME FROM DBA_DATA_FILES  WHERE TABLESPACE_NAME = 'USERCFT'
結果 
FILE_NAME
D:\ORACLE\ORADATA\CFTDB\USERCFT.DBF

2.表領域を拡張

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SQL> ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\CFTDB\USERCFT.DBF' RESIZE 1024M;
SQL> ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\CFTDB\USERCFT.DBF' RESIZE 1024M;
SQL> ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\CFTDB\USERCFT.DBF' RESIZE 1024M;

 

Oracle

Posted by arkgame