Re: Change Schema name???

From: Joe Kazimierczyk <kazimiej_at_bms.com>
Date: 1997/01/17
Message-ID: <32DFAF73.41C67EA6@bms.com>#1/1

Komix Hui wrote:
>
> Angelito Dizon wrote:
> >
> > Is it possible to change the name of a schema?
> >
>
> Oracle does not provide such facilities.
> You can achieve your purpose with other methods:
>
> export all objects in the schema;
> drop the schema;
> create a new user;
> import the exported data;
>

Another method, which is unsupported, but does work:

update sys.user$ set name='NEWUSERNAME'

        where name='OLDUSERNAME';

You must then shutdown and restart the database for this change to be recognized.

You also need to fix any synonyms that refer to the oldusername, since synonyms actually store the name and not the user#.

---

Joe Kazimierczyk
kazimiej_at_bms.com Received on Fri Jan 17 1997 - 00:00:00 CST