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 do you rename a Table in Oracle

Re: How do you rename a Table in Oracle

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Mon, 18 May 1998 07:24:03 -0400
Message-ID: <35601A53.62F8B60B@oracle-dba.com>


rename <table> to <newtable>;

joe

reb_at_timevest.com wrote:

> What would be the Oracle equivalent to the sybase command
>
> sp_rename "OldTableName", "NewTableName"
>
> ?!

--
Joseph S. Testa, Oracle Database Administrator Vice-President Ohio Oracle Users Group, http://www.ooug.org OOUG welcomes Steven Feuerstein to Columbus OH in Oct, if your company is interested in becoming a corporate sponsor for this event, send mailto:vice_pres_at_ooug.org.
Want some remote DBA work done? mailto:teci_at_oracle-dba.com ICQ http://wwp.mirabilis.com/2832230 Received on Mon May 18 1998 - 06:24:03 CDT

Original text of this message

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