1.查看表空间文件存放路径
1 |
SQL> SELECT tablespace_name, file_id, file_name, round(bytes / (1024 * 1024), 0) total_space FROM dba_data_files ORDER BY tablespace_name; |
2.扩展ncc_data01表空间
1 |
SQL> alter tablespace nnc_data01 add datafile ‘D:\ORACLE\PRODUCT\10.2.0\ORADATA\NC\DATAFILE\NNC_DATA01_01.DBF‘ size 1000M autoextend on next 50M; |
3.扩展ncc_index01表空间
1 |
SQL> alter tablespace nnc_index01 add datafile ‘D:\ORACLE\PRODUCT\10.2.0\ORADATA\NC\DATAFILE\NNC_INDEX01_01.DBF‘ size 1000M autoextend on next 50M; |