---
title: "查询表空间"
author: "hotjava"
date: "2008-05-29T21:00:48Z"
tags: []
slug: "untitled"
draft: false
lastmod: "2008-05-29T21:00:48Z"
id: 198438
url: "https://hotjava.iteye.com/blog/198438"
---

PLSQL中，－－&gt; REPORT--&gt;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