Re: Change OWNER on Package Objects?
From: Gleb Otochkin <gleb.otochkin_at_gmail.com>
Date: Wed, 21 Dec 2011 06:32:36 -0500
Message-Id: <4D58A707-7E8E-4C79-A339-36BC1B178C36_at_gmail.com>
Recreate packages and package bodies with proper owner and drop old packages and bodies in the SYSTEM scheme. You can add owner as prefix to package name if you create packages from system. As example "create or replace package <package owner>.<package name>
Date: Wed, 21 Dec 2011 06:32:36 -0500
Message-Id: <4D58A707-7E8E-4C79-A339-36BC1B178C36_at_gmail.com>
Recreate packages and package bodies with proper owner and drop old packages and bodies in the SYSTEM scheme. You can add owner as prefix to package name if you create packages from system. As example "create or replace package <package owner>.<package name>
Thanks,
Gleb
On 2011-12-20, at 6:52 PM, Anthony Ballo wrote:
> I'm trying to figure out the easiest way to change the owner on a few
> packages that accidentally were created under SYSTEM? Everything I come
> up with concerning Packages points to recompiling. Is there a ALTER
> PACKAGE cmd that changes the OWNER?
>
> Thanks,
>
> Anthony
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 21 2011 - 05:32:36 CST