Re: Schema and Rename

From: Milly Kander <mkander_at_.wh.whoi.edu>
Date: Fri, 22 Apr 1994 17:07:24 GMT
Message-ID: <Coo7KC.51C_at_netnews.whoi.edu>


In article <1994Apr21.105311.29761_at_scammell.ecos.tne.oz.au> srh_at_scammell.ecos.tne.oz.au (Shane Hocking) writes:
>In article <kuanCoKww6.EEC_at_netcom.com> kuan_at_netcom.com (Kuan) writes:
>>Dear Oracle People:
>>
>> Can you give me one reason why you allow -
>>
>> 1. CREATE SCHEMA.TABLE
>> 2. ALTER SCHEMA.TABLE
>> 3. DROP SCHEMA.TABLE
>>
>> BUT, you don't allow
>>
>> 4. RENAME SCHEMA.TABLE
>>
>>What's the difficulty in this problem from technical point of view ?
>
>I have also wondered this since rows in the base table obj$ are
>identified uniquely by the column obj#. Surely all operations internally
>would use this number and not the name column. It would be a reasonable
>restriction for the object to be not in use for the RENAME to take place.
>
>It also seemed strange that in V7 you can use the "CREATE OR REPLACE" syntax
>for a view but not a table.
>
>Shane
>
>
>--
>----------------------------------------------------------------------------
>Shane Hocking Email : srh_at_scammell.ecos.tne.oz.au
>Information Technology Group
>Telecom Australia

maybe i am missing something here, but according to page 4-337 in v7 sql manual, you may indeed rename tables, views etc. as long as they are in your schema.

milly Received on Fri Apr 22 1994 - 19:07:24 CEST

Original text of this message