Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to change the name of a table
Both ways will work
GC wrote:
> John Clarke wrote:
> >
> > rename TableNameX to TableNameY
> >
> > "M. Fuchs" wrote:
> >
> > > how can i change the name of a table for ex. from TableNameX to
> > > TableNameY?
>
> Close - 'alter table <foo> rename to <bar>;'
>
> Cheers,
> GC
Received on Mon Aug 07 2000 - 00:00:00 CDT