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 -> Tablespace file

Tablespace file

From: Zachary Agatstein <Zachary.Agatstein_at_atsc.allied.com>
Date: Tue, 1 Dec 1998 10:26:36 -0500
Message-ID: <7411ut$21a81@tmpsp002.tmpprv.allied.com> 





Some time ago I created a tablespace and a datafile for it.  As it turned
out, this file is much too large, and the tablespace runs out of its extents
when only a fraction of the file is used.  Is there any way, other than
dropping and re-creating the tablespace with all the tables in it, to reduce
the size of that datafile?



Thanks in advance.


Zach Agatstein


Received on Tue Dec 01 1998 - 09:26:36 CST












Original text of this message













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