Re: Moving tables with constraints

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 24 Jul 2002 18:53:37 +0100
Message-ID: <1027533132.29954.0.nnrp-01.9e984b29@news.demon.co.uk>

It makes a big difference -

Look at:

alter table XXX move;
followed by

alter index YYY rebuild;

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
 UK  Sept
 Australia August
 Malaysia September
 USA x 2  November

http://www.jlcomp.demon.co.uk/seminar.html

Kip Gray wrote in message <3D3EE8A8.6050803_at_learningframework.com>...


>

>Peering into my crystal ball (which just came back from the repair

>shop), Oracle8i Rel 2 (aka 8.1.7).

>

>Kip

>

Received on Wed Jul 24 2002 - 12:53:37 CDT