Re: Change OWNER on Package Objects?
- From: Anthony Ballo <anthony.ballo@xxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 23 Dec 2011 13:21:31 -0800
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@xxxxxxxxx> 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
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
