Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> reclaiming space from SYSTEM tablespace.

reclaiming space from SYSTEM tablespace.

From: Ray Teale <ray_at_BLAHholly.com.au>
Date: Mon, 7 Apr 2003 14:39:05 +1000
Message-ID: <Xe7ka.284$2y1.4018@nnrp1.ozemail.com.au> 





Oracle 8.1.6



I have noticed that the datafile for the SYSTEM tablespace is huge.
I would like to move the SYSTEM tablespace to a correctly sized datafile and
reclaim the wasted disk space.


Is there an easier way than exporting - recreating the database and
importing?



Ta



Ray
Received on Sun Apr 06 2003 - 23:39:05 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US