Oracle-L: RE: Alter table move command

From: kkennedy <kkennedy_at_firstpoint.com>
Date: Tue, 09 Jul 2002 09:18:29 -0800
Message-ID: <F001.0049275B.20020709091829@fatcity.com>

The alter table move command changes every rowid in the table. All indexes on the table are flagged as unusable because of that. You will need to rebuild all the indexes following the table move. Kevin Kennedy
First Point Energy Corporation

-----Original Message-----
Sent: Tuesday, July 09, 2002 9:45 AM
To: Multiple recipients of list ORACLE-L

Hi All,

I want to use the alter table move command (under 9i) to change the storage parameters for a couple of tables. The tables will remain in the current tablespace. Will I need to rebuild any indicies on that table, or will the rowid's be updated automatically.

I've looked in the FM, but I don't see any caveats about indicies when using the move option. So, am I safe in assuming that I don't need to worry about them?

Thanks,

Alan Davey
adavey_at_competitrack.com
212-604-0200 x106

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Alan Davey
INET: adavey_at_competitrack.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: kkennedy
INET: kkennedy_at_firstpoint.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------