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 -> Space and fragmentation in Oracle 7.3.4

Space and fragmentation in Oracle 7.3.4

From: Eric DUCHET <eric.duchet_at_free.fr>
Date: Thu, 02 Dec 1999 14:37:41 GMT
Message-ID: <Vuv14.356$kG3.1749162@nnrp1.proxad.net> 





Hi,



I have a simple question:



How Oracle recover  the free space whenyou delete data from tables ?



Is there any tools to compact a table online without doing an export/import
?



I have a table with 1 000 000 rows (1 extend) nad Initial Extend up to 100 M
I delete all the rows from my table


When I launch the query select count(*) ,
it takes a lot of time.


What does it mean ? Oracle makes a full scan of the table even if there is
no data ?



Thanx




Received on Thu Dec 02 1999 - 08:37:41 CST












Original text of this message













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