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 needed

Re: defrag needed

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 22 Aug 2001 08:22:24 +0100
Message-ID: <998465256.3501.1.nnrp-08.9e984b29@news.demon.co.uk>

For partitioned tables you use syntax
to move each partition individually.

    alter table xyx move partition pqr;

--
Jonathan Lewis

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

For latest news of public appearances
See http://www.jlcomp.demon.co.uk

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.




Ban Spam wrote in message ...

>"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in
>news:998295200.5883.0.nnrp-12.9e984b29_at_news.demon.co.uk:
>[...snip...]
>>
>> The code/test cost of implementing a
>> table rebuild is pretty small by comparison.
>> (BTW - use MOVE table rather than
>> copy and rename - it eliminates the
>> hassle of sorting out privileges and
>> invalidations due to dependencies).
>>
>
>If the source table in an ALTER TABLE table_name MOVE
>is partitioned, will the destination table also be partitioned?
>
>What happens if/when the source table is partitioned
>across multiple tablespaces?
Received on Wed Aug 22 2001 - 02:22:24 CDT

Original text of this message

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