Re: Rename table

From: Joe Kazimierczyk <joseph.kazimierczyk_at_bms.com>
Date: Tue, 22 May 2001 11:45:56 -0400
Message-ID: <3B0A89B4.F55DA9A6@bms.com>

"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 - 10:45:56 CDT