Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Rename table
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