Re: Change OWNER on Package Objects?

From: Anthony Ballo <anthony.ballo_at_onecall.com>
Date: Fri, 23 Dec 2011 13:21:31 -0800
Message-ID: <CB1A3025.16D66%anthony.ballo_at_onecall.com>

Thanks to all than answered - I ended up rerunning the Oracle scripts over in the correct account. Wasn't sure if ALTER cmd had anything new for me but it was quickly confirmed by other list members.

Now I'm cleaning up the tables, indexes, packages, functions that it left behind in the SYSTEM schema making DDL cmds as a backup JIC before dropping.

Thanks again,

Anthony

On 12/21/11 3:32 AM, "Gleb Otochkin" <gleb.otochkin_at_gmail.com> wrote:

>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

Received on Fri Dec 23 2011 - 15:21:31 CST