Re: Rename a table

"Mario Koch" <m.koch_at_md-netz.de> 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
>

You cannot place a table into another schema by renaming it that way.

try this to rename it:

rename table1 to table2;

hth, Received on Tue Jun 15 2004 - 14:02:51 CDT