Re: Change Schema name???

From: Komix Hui <huikomix_at_dt.com.hk>
Date: 1997/01/17
Message-ID: <32E03F66.4A87@dt.com.hk>#1/1

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;

But this procedure will cause several side-effects:

All objects in other schemas which are dependent on the objects of the old schema will be invalidated, such as views, triggers, stored procedures/packages, constraints; Some objects may have to be recreated, such as indexes;

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Assistant MIS Manager                Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049

Received on Fri Jan 17 1997 - 00:00:00 CST