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: kstahl <ktsahl_at_yahoo.com>
Date: Tue, 15 Jun 2004 20:08:40 -0400
Message-ID: <M-WdnS2I1NoUElLdRVn-vA@comcast.com>


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 ...
>>

>
> Do not confuse tablespaces with schemas...
>
> The table name is owner.tablename so
> just use the tablename part in your renaming..
>
> Can you do a
> desc table1?
>
>

That assumes that the person doing the change is logged into the schema that owns the table. Otherwise the fully qualified name must be used. Received on Tue Jun 15 2004 - 19:08:40 CDT

Original text of this message

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