Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Rename Table name in Oracle 8i

Re: Rename Table name in Oracle 8i

From: TurkBear <johng_at_mm.com>
Date: 2000/04/11
Message-ID: <38f38f3f.23096851@news>#1/1

Try

Rename old_table_name to new_table_name

I'm not sure about the impact this would have on any dependent foreign keys, etc...

"J Gao" <jie.gao_at_tequilasoftware.com> wrote:

>Hi, There,
>Is there any easy way to rename the table name in Oracle 8i. In SQL Server
>7, sP_rename stored procedure will do this job. I wonder if Oracle 8i has
>the similar one. Thanks.
>
>J Gao
>
Received on Tue Apr 11 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US