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 -> Re: Defrag Tablespaces ? How ?

Re: Defrag Tablespaces ? How ?

From: Torsten Borchert <T.Borchert_at_DeutschePost.de>
Date: Tue, 13 Oct 1998 12:39:12 +0100
Message-ID: <36233BE0.1EBDEEFF@DeutschePost.de> 





Hi,



you can't export a tablespace, you can only export all tables in a
tablespace, indexes you must drop and recreate them (Release < 7.3) ...
Then you must drop the tablespace and recreate it or
set default storage (pctincrease 1) for it ( not 0) so that SMON
coalesces all free extents or


in Oracle release greater 7.3 "alter tablespace USERS coalesce;"



S Green wrote:


> 


> One approach is to export the tablespace and then import it back.


Received on Tue Oct 13 1998 - 06:39:12 CDT












Original text of this message













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