Re: Change owner of oracle objects ??

From: <alt_at_interchange.co.uk>
Date: Wed, 09 Dec 1998 16:39:16 GMT
Message-ID: <74m93k$aku$1@nnrp1.dejanews.com>

Do an export then import the objects to the new users account using:

imp usr/pwd file=file.dmp fromuser=oldschemaname touser=newschemaname log=file.log

Watch out that the newschemaname doesn't hold any objects that may have the same name as the objects coming from the oldschemaname.

In article <366e6c64.0_at_d2o61.telia.com>, "Magnus Rosenquist" <maro_at_gbg.ifsab.se> wrote:
> Hi !
>
> Does anybody know of a way to change the
> owner of all created oracle objects in a users schema ?
>
> Of course you can recreate them in the new users schema,
> but is there another way you can achieve this ??
>
> Response is greatly appreciated!!
>
> regards,
> Magnus
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 09 1998 - 10:39:16 CST