Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Renaming a table
"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
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Thu May 06 2004 - 15:42:15 CDT