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: Best way to reorganize a schema

Re: Best way to reorganize a schema

From: wegorz <wegorz_at_winuel.com.pl>
Date: Mon, 20 Nov 2000 09:37:25 +0100
Message-ID: <8vanns$2pt$1@news.tpi.pl> 






>Any better way of doing this without vendor tools?




In Oracle 8i you can use 'alter table ... move tablespace ...' and 'alter
index ... rebuild tablespace ...'. Remember to check if you have some
'unusable' indexes.



Andrew
Received on Mon Nov 20 2000 - 02:37:25 CST












Original text of this message













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