Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Rename a table
"Turkbear" <john.g_at_dot.spamfree.com> schrieb im Newsbeitrag
news:irhuc092dikqr96c0um4quja17a8cl16gt_at_4ax.com...
> "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,
>
I try it , but with error: ORA-04043: Object not exists
I realy know, this object exists (in the tablespace tbsp1).
What now ?
Best Regards ...
Received on Tue Jun 15 2004 - 14:43:53 CDT