Re: Alter name of a table

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 22 Sep 1999 15:25:43 +0100
Message-ID: <7saos6$b9l$1@soap.pipex.net>

or if you want to create a backup of the existing one as well, for when that app breaks..

create table table2 as select * from table1

Niall
Oracle DBA Audit Commission UK
<owais_anjum_at_my-deja.com> wrote in message news:7rq6uv$sb2$1_at_nnrp1.deja.com...
> In article <7rpcf7$hfg$1_at_perki.connect.com.au>,
> "Tom Zamani" <tom_at_taten.com.au> wrote:
> > Is there any way to change the name of a table?
> > Like alter table .....
> > Please help me out.
> > Tom
> >
> >
>
> rename table1 to table2;
>
> pretty straight forward hmmm :)
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Wed Sep 22 1999 - 09:25:43 CDT