How full the SYSTEM tablespace is?

From: Grace Tsai <gtsai_at_bnl.gov>
Date: Fri, 23 Apr 1999 11:06:02 -0400
Message-ID: <37208C5A.76F2F639@bnl.gov>

I am preparing to upgrade our Oracle Server from version 7.3.2.3.0 to 8.0.5.
In the manual "Oracle8, Release 8.0.5, Installation Guide for AIX-Based Systems",
At the bottom of the page 5-7, it says one of the steps to "Prepare the Migration Utility" is

"

Verify Space in SYSTEM Tablespace

An Oracle8 database requires approximately 150% as much space in the SYSTEM
tablespace as the equivalent Oracle7 database. Verify that the SYSTEM tablespace
in your Oracle7 database is large enough, before migrating the database.

Does anybody know to to check how full an Oracle tablespace is? Thanks very much in advance.

Grace Tsai
Brookhaven National Lab Received on Fri Apr 23 1999 - 10:06:02 CDT