Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Rename a table
Turkbear wrote:
> "Mario Koch" <m.koch_at_md-netz.de> wrote:
>
>
>>"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 ... >>