Re: Alter name of a table

From: Chetan Wagle <chetanw_at_yahoo.com>
Date: Thu, 23 Sep 1999 10:45:19 +0530
Message-ID: <7sccuo$8aj$1@herald.ctp.com>

Hi niall,

I have heard of an undocumented command called 'alter table <name> rename <newname>'

Check it out. The other solutions won't give you your triggers and referential constraints.

HTH, Chetan
Bangalore, India

Niall Litchfield wrote in message <7saos6$b9l$1_at_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 Thu Sep 23 1999 - 00:15:19 CDT