Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Mailing Lists ->
Oracle-L ->
RE: ALTER TABLE REBUILD command - ***RESOLVED***
RE: ALTER TABLE REBUILD command - ***RESOLVED***
- "Armstead, Michael A" <maa25681_at_glaxowellcome.com>
wrote:
> 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).
>
> --
> 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 - 19:00:38 CDT
Original text of this message