Brian Peasland wrote:
> "Howard J. Rogers" wrote:
>
>>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
>
>
> Both RENAME and ALTER TABLE RENAME were available in 8.1.5 and 8.0.4
> according to the docs. The docs don't have ALTER TABLE RENAME for Oracle
> 7.3.4, but there is the RENAME command.
>
> HTH,
> Brian
Perfect. Thanks Brian.
Regards
HJR
Received on Thu May 06 2004 - 18:44:59 CDT
