Re: Reorg Tables
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 21 Dec 2000 18:44:48 +0800
Message-ID: <3A41DF20.3C9F_at_yahoo.com>
Date: Thu, 21 Dec 2000 18:44:48 +0800
Message-ID: <3A41DF20.3C9F_at_yahoo.com>
Frederic Mockel wrote:
>
> Hi Newsgroup,
>
> i heard about a possibility to reorganize a whole table with one command.
>
> Could this be possible or not
>
> Freddy
8i - alter table XXX move
you will need to rebuild any indexes on the table if it contains rows.
HTH
-- =========================================== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue"Received on Thu Dec 21 2000 - 11:44:48 CET