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

Re: Rename table

From: David Busby <dbusby3_at_slb.com>
Date: Thu, 17 May 2001 06:32:56 -0500
Message-ID: <3B03B6E8.E90B29B1@slb.com>

create table a as (select * from b);

B is the old table.
A is the new table.

Then before you drop B make sure you have created any indexes, relationship links etc..

zifeng li wrote:

> How to rename a table? Thanks. Zifeng
Received on Thu May 17 2001 - 06:32:56 CDT

Original text of this message

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