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: Asko Tiidumaa <askot_at_math.ut.ee>
Date: 14 Oct 1998 10:48:10 GMT
Message-ID: <701vha$j5r$1@kadri.ut.ee> 





> 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;"





but 24*7 availability?




Asko Tiidumaa

Received on Wed Oct 14 1998 - 05:48:10 CDT












Original text of this message













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