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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to rename a table ?

Re: How to rename a table ?

From: Martyn Richard Jones <martyn1_at_ibm.net>
Date: 1997/01/02
Message-ID: <5ag82t$sme$1@news-s01.ny.us.ibm.net>#1/1

aak2_at_Ra.MsState.Edu (Atif Ahmad Khan) writes: >
> 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.
>
> Thanks in advance for any pointers.
>
> Atif Khan
> aak2_at_ra.msstate.edu

Look up RENAME.

Martyn Jones Received on Thu Jan 02 1997 - 00:00:00 CST

Original text of this message

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