Re: Renaming a table

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 07 May 2004 06:18:34 +1000
Message-ID: <409a9d90$0$12574$afc38c87@news.optusnet.com.au>

paddy_nyr wrote:

> "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
> news:409a991d$0$20347$afc38c87_at_news.optusnet.com.au...
> 

>>The ability to rename a table (alter table X rename to Y) was there in
>>8.1.6... but was it there in 8.1.5, 8.0, or 7? Strangely, I don't have
>>those CDs to hand to find out.
>>
>>Anyone remember that far back??!
>>
>>Regards
>>HJR
>>

>
> On 7.3 it was rename table_a to table_b. hth.

Well, you can still do it that way in 10g if you're only renaming a table in your own schema, but thanks. That rather suggests it's been around a lot longer than I seem to remember.

Regards
HJR Received on Thu May 06 2004 - 15:18:34 CDT