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 -> drop table + free space in tablespaces

drop table + free space in tablespaces

From: Diana <diana.krapf_at_gmx.de>
Date: 11 Oct 2004 08:09:15 -0700
Message-ID: <a9e6f2ec.0410110709.1fef3584@posting.google.com> 





hello,



does the filesize of the tablespace's datafile shrink if I drop a
table or an index?



is it possible to compress the datafiles without exporting and
re-importing the data?


which tools can I use?
Received on Mon Oct 11 2004 - 10:09:15 CDT












Original text of this message













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