Hi Jonathan,
Even this may not be the case (in my opinion I could be mistaken, my
respects for every one).
As you know any index is made of branching blocks and leaf blocks.
When we build an index, it's mainly to get rid of deleted rows/entries in
the leaf blocks and reclaim that space. Also re
EMAIL PROTECTED]]
> Sent: 21 March 2002 17:08
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Rebuilding Index Organised Tables (IOTs)
>
>
> 8.1.5 and 8.1.7 both support
> alter table iot_tab move
> for IOTs - is there a special bug in 8.1.6 ?
>
>
gt; Subject: Re: Rebuilding Index Organised Tables (IOTs)
>
>
> Correct, and apologies, it's too easy to give
> the quick and simple answer.
>
> If you want to rebuild the whole thing, without
> changing tablespaces, then:
>
> alter table iot_tab move overf
8.1.5 and 8.1.7 both support
alter table iot_tab move
for IOTs - is there a special bug in 8.1.6 ?
Your own notes even describe this:
|The move_table_clause rebuilds the index-organized table's primary
|key index B*-tree. The overflow data segment is not rebuilt unless
the
|OVERFLOW keyword
Correct, and apologies, it's too easy to give
the quick and simple answer.
If you want to rebuild the whole thing, without
changing tablespaces, then:
alter table iot_tab move overflow;
You can't move the overflow with an online move,
of course (except in Oracle 9, I expect).
If you also
Many thanks to all of those people who advised.
Unfortunately we are running on 8.1.6.3, so cannot do "alter table move.. "
as well :(
If you get any info, please let me know.
Meanwhile, here are few bits that I gathered in IOTs.
Cheers
Kumanan
Why use Index-Organized Tables
* Fast key
It seems to me that alter table move --> just rebuilds the the
branching part of the index.
So if this is the case---> export & import or create table as ... are
the best way to do the real job.
Corrections and feedback are welcomed.
Waleed
-Original Message-
Sent: Wednesday, March 20
Alter table move;
also
alter table move online;
but there are still some nasty bugs
with online index rebuilds (which is
what this actually does) so it might
be safer not do use the option for an
IOT.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http
You can do a "ALTER TABLE MOVE" if you have 8i or >...
Check the docs for more details...
http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a85397/statem2a.
htm#2055687
HTH
Tim
-Original Message-
Sent: Wednesday, March 20, 2002 4:15 PM
To: Multiple recipients of list ORACLE-L
You can do an ALTER TABLE ... MOVE ... , but in versions prior to 8.1.7.1 doing that
with the ONLINE option can cause rollback corruption.
Beth
-Original Message-
Sent: Wednesday, March 20, 2002 3:50 PM
To: Multiple recipients of list ORACLE-L
Is that possible?
Thanks
Kumanan
--
Pl
Is that possible?
Thanks
Kumanan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
11 matches
Mail list logo