Re: No way to drop or rename column in Oracle 8?

From: Rick Losey <rlosey_at_hotmail.com>
Date: Tue, 22 Jun 1999 23:49:54 -0600
Message-ID: <ez_b3.177$U16.233@news.megsinet.net>

Prior to 8i, you must backup the data, drop the table, recreate it with the modifications, and restore the data.

8i allows you to do direct column mods (I believe)

Rick

Doug Cowles <dcowles_at_bigfoot.com> wrote in message news:376961E9.8678618B_at_bigfoot.com...
> Self - explanatory. I know there is some kind of new functionality for
> these kinds of things in Oracle 8 - maybe it's 8i? In any case, is
> there any way to do it in 8.0.5,
> or is there anything new at all in regards to dropping, modifying,
> renaming, columns and/or tables in 8.0.5.
>
> Thanks
> - Dc.
>
Received on Wed Jun 23 1999 - 00:49:54 CDT