RE: ALTER TABLE REBUILD command - ***RESOLVED***

Thanks Waleed and Charlie,

It looks like the ALTER TABLE MOVE command was implemented in 8.1.6. It also looks like when you use it, all the indexes on the table become invalid, forcing you to do an ALTER INDEX REBUILD.

Thanks, again!

Michael Armstead
Database Administrator, OCP-Certified
Corporate & Finance Information Systems
Glaxo Wellcome

> -----Original Message-----
> From: Khedr, Waleed [SMTP:Waleed.Khedr_at_FMR.COM]
> Sent: Monday, September 25, 2000 3:02 PM
> To: 'ORACLE-L_at_fatcity.com'
> Cc: Armstead, Michael A
> Subject: RE: ALTER TABLE REBUILD command
>
> There is alter table move_clause in 8.1.6.
>
> Regards
>
> Waleed
>
> -----Original Message-----
> From: Armstead, Michael A [mailto:maa25681_at_glaxowellcome.com]
> Sent: Monday, September 25, 2000 2:56 PM
> To: Multiple recipients of list ORACLE-L
> Subject: ALTER TABLE REBUILD command
>
>
> I heard somewhere that we will soon have the ALTER TABLE REBUILD command.
> The command will allow tables to be moved from one tablespace to another,
> defragment a table, provide the ability to modify of the INITIAL
> parameter,
> and maybe some other things.
>
> Is the rumor true? If so, when is the feature expected to be available?
>
> Michael Armstead
> Database Administrator, OCP-Certified
> Corporate & Finance Information Systems
> Glaxo Wellcome
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Armstead, Michael A
> INET: maa25681_at_glaxowellcome.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).
Received on Mon Sep 25 2000 - 14:15:53 CDT