Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Rename a table
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