PLSQL中,--> REPORT-->Total Free Space
返回结果如下:
Total Free Space |
Tablespace | Space (bytes) |
---|---|
RMS_DATA | 71,091,486,720 |
RMS_DATAHIS | 99,220,455,424 |
RMS_INDX | 22,262,644,736 |
RMS_INDXHIS | 99,866,902,528 |
SYSAUX | 40,445,345,792 |
SYSTEM | 4,722,130,944 |
UNDOTBS1 | 43,328,077,824 |
UNDOTBS2 | 23,161,536,512 |
USERS | 525,795,328 |
============================================
修改表的表空间
alter table FUNC_NODE move tablespace WORKFORCEDATA