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

Home -> Community -> Usenet -> c.d.o.misc -> Tablespace-Datafiles unused space ?

Tablespace-Datafiles unused space ?

From: Stefan Leidinger <stefan.leidinger_at_aon.at>
Date: Tue, 8 Jul 2003 10:42:30 +0200
Message-ID: <3f0a83fc$0$18666$91cee783@newsreader01.highway.telekom.at> 





Hi,



I have a problem with the datafiles of an Oracle-tablespace:



There are three datafiles, if I want to create an index with 200MB
it will be created in the 3rd datafile. I think the 1st datafile is very
fragmented ...



How can I compress or defragment the datafiles? (V 8.1.7)



Example: www.schwarzmueller.com/tablespace.jpg



Every answer is welcome,



Greetings from Austria



Stefan
Received on Tue Jul 08 2003 - 03:42:30 CDT












Original text of this message













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