Re: Change OWNER on Package Objects?

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-l


Other related posts: