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: Rename a table

Re: Rename a table

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Wed, 16 Jun 2004 00:39:31 GMT
Message-ID: <7FMzc.57010$%i1.8459@edtnps89>


Mario Koch wrote:

> How can i rename a table. I have test with:
> rename tbsp1.table1 to tbsp2.table2
> But i get an error: table not exists.
> I work in SQLPlusWorksheet .
> Best regards Mario

Are you using the Tablespace name as part of the table name?

If yes, change that to the Table Owner. Received on Tue Jun 15 2004 - 19:39:31 CDT

Original text of this message

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