Re: Rename a table

"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? Received on Tue Jun 15 2004 - 15:55:52 CDT