Re: Rename table

You can use the DBA STUDIO's 'create like' command to duplicate a user's attributes to a new name..

Joe Kazimierczyk <joseph.kazimierczyk_at_bms.com> wrote:

>"Daniel A. Morgan" wrote:
>
>> Joe Kazimierczyk wrote:
>>
>> > > The following is quoted from 9i_new_features.pdf at technet.oracle.com:
>> > >
>> > > "Additionally, many logical attributes can be changed . Column names, types, and
>> > > sizes can be changed. Columns can be added, deleted, or merged. The primary
>> > > restriction is that the primary key of the table cannot be modified."
>> > >
>> > > So it is coming in just another month.
>> > >
>> >
>> > Will 'rename user' be in 9i? That's one command I've
>> > sorely missed. We've asked people to postpone their
>> > marriages and divorces until Oracle gives us a 'rename
>> > user'. ;-)
>>
>> It is not in the paper. But I would be happy to build a small package that would
>> accomplish this goal as it would be no more than a day or two's work.
>
>Already have one, but thanks. My script accomplishes this by dropping the old
>username, then creating the new name, then trying to redo any grants, recreate
>objects... It would still be much easier if Oracle supplied a rename user command.
>
Received on Tue May 22 2001 - 11:16:48 CDT