Re: change the schema name

From: <xsun1913_at_my-dejanews.com>
Date: Tue, 20 Oct 1998 18:20:42 GMT
Message-ID: <70ik9q$174$1@nnrp1.dejanews.com>

In article <362C0C5B.5092_at_gpu.srv.ualberta.ca>, Brian Yan <by2_at_gpu.srv.ualberta.ca> wrote:
> Hi there,
>
> How can I change a schema's name in Oracle734 for HPUX? Thank you.
>
> Brian
>

You could export all the objects (data) from the old schema, re-create these objects with a new schema, and then import all the objects (data) from the export file (make sure everything is fine before dropping the old schema).

Xuening Sun

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 20 1998 - 13:20:42 CDT