查询表空间
PLSQL中,--> REPORT-->Total Free Space
返回结果如下:
Total Free Space
TablespaceSpace (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