Re: renaming a table

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 7 Mar 2000 13:47:42 +0100
Message-ID: <952433442.19954.2.pluto.d4ee154e@news.demon.nl>

jbraddock <jbraddockNOjbSPAM_at_sockets.net.invalid> wrote in message news:074142ba.8243097f_at_usw-ex0104-031.remarq.com...
> Indic3 is the table name. I left out that we are using Oracle
> 8, and it states that the RENAME command can be used for
> tables. We just can't get it to work. As there are 3 million
> plus records in the table, I don't really want to have to
> export/import it.
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>

rename table <table_1> to <table_2> already worked in 7. What errors are you getting.
Also you could resolve this (partly) by create table ... as select * from table_1 etc.

Hth,
Sybrand Bakker, Oracle DBA Received on Tue Mar 07 2000 - 06:47:42 CST