Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: defrag needed
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 ...Received on Wed Aug 22 2001 - 02:22:24 CDT
>"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?