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: Tablespace Fragmentation

Re: Tablespace Fragmentation

From: Tlcbus <tlcbus_at_aol.com>
Date: 1997/10/20
Message-ID: <19971020235501.TAA24529@ladder01.news.aol.com>#1/1 







First you have to run a query to find out how many users are mapped to that
 tablespaces(you can not export by tablespace only by user). Export by user
 with compress =y , drop tablespace including contents, and import user by user
 to the tablespace. If tablespace is an index tablesapce you can recreated
 indexes with corrected initial and next extent(no need for export/import)



Ted Chyn
Received on Mon Oct 20 1997 - 00:00:00 CDT












Original text of this message













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