Re: ALTER TABLE REBUILD command

From: Michael Ray <Michael.Ray_at_trw.com>
Date: Wed, 27 Sep 2000 08:26:06 -0700
Message-Id: <10632.118007@fatcity.com>

Longs are currently not supported apparently (MOVE is essentially a fancy = CTAS). One of the Metalink forums suggested using the SQL*Plus Copy = command or export/import as a workaround. in this case.

Good luck!

Michael Ray
CIM Engineer
TRW Marshall
217-826-3011 x2438

>>> <ORACLE-L_at_fatcity.com> 09/27 3:05 AM >>> From: "Charlie Mengler" <charliem_at_mwh.com> Date: Tue, 26 Sep 2000 05:59:57 -0700
Subject: Re: ALTER TABLE REBUILD command - LONG ?

Has anyone tested what affect the ALTER TABLE MOVE command has on Primary Key/Foreign Key constraints, triggers, or packages that reference the table being moved? If so, what other cleanup actions are required after using this command?

Michael Henderson wrote:
>=20

> Plus, you can't seem to move a table with a LONG column. Anyone know = how to move a table with these ? Received on Wed Sep 27 2000 - 10:26:06 CDT