Re: How to rename a table ?
From: Lun Wing San (Oracle) <"Lun>
Date: 1996/12/27
Message-ID: <32C4AA85.2805_at_qrcsun.qrc.org>#1/1
Date: 1996/12/27
Message-ID: <32C4AA85.2805_at_qrcsun.qrc.org>#1/1
Atif Ahmad Khan wrote:
>
> I have a table that is serving data to web users around the clock.
> Its a rather huge table, has a primary key and a couple of indices also.
>
> I figured that instead of trying to update 5,000 rows in the main
> 200,000 rows table, I may be better off doing it all to a temporary
> table while dropping its indices to improve performance and when I am
> done, drop the main table and rename the temporary table as the main table.
>
> Is this possible ? Also is this a good solution ? I looked up the alter
> table command in the SQL Reference manual and did not find a way to rename
> a table.
You can rename a table by using RENAME old_tablename TO new_tablename. However, it is version dependent.
--- Name : Lun Wing San Title : Oracle Application Developer of Hong Kong Productivity Council Oracle Database Administrator and System Administrator of QRC Phone : (852)27885841Received on Fri Dec 27 1996 - 00:00:00 CET