Re: ALTER TABLE REBUILD command

From: Michael Henderson <MHenders_at_tvnz.co.nz>
Date: Tue, 26 Sep 2000 15:19:26 +1200
Message-Id: <10630.117827@fatcity.com>

Plus, you can't seem to move a table with a LONG column. Anyone know how = to move a table with these ?

Mike.

Michael Henderson, DBA
http://www.nzoom.com
DDI: +64-9-916 6941 Fax: +64-9-308 9614 Mob: 021-465 466

>>> maa25681_at_glaxowellcome.com 09/26 8:22 >>> 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]=20
> Sent: Monday, September 25, 2000 3:02 PM
> To: 'ORACLE-L_at_fatcity.com'=20
> Cc: Armstead, Michael A
> Subject: RE: ALTER TABLE REBUILD command

>=20

> There is alter table move_clause in 8.1.6.

>=20

> Regards

>=20

> Waleed

>=20

> -----Original Message-----
> From: Armstead, Michael A [mailto:maa25681_at_glaxowellcome.com]=20
> Sent: Monday, September 25, 2000 2:56 PM
> To: Multiple recipients of list ORACLE-L
> Subject: ALTER TABLE REBUILD command

>=20
>=20

> 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.

>=20

> Is the rumor true? If so, when is the feature expected to be available?

>=20

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

>=20
>=20
>=20

> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
> --=20
> Author: Armstead, Michael A
> INET: maa25681_at_glaxowellcome.com=20

>=20


> 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).

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: Armstead, Michael A
INET: maa25681_at_glaxowellcome.com=20

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 Received on Mon Sep 25 2000 - 22:19:26 CDT

Re: ALTER TABLE REBUILD command - LONG ?