Re: ora-04068

From: <catherine_devlin_at_purpleturtle.com>
Date: 24 May 2001 23:13:16 GMT
Message-ID: <9ek4ic$8hr$1@news.netmar.com>

>ORA-04067: not executed, package body "SYSTEM.DBMS_APPLICATION_INFO" does

                                        ^^^^^^

Did you try to run the script while connected as SYSTEM?

>I checked the package inside the db and this is what I get:
>OWNER SYNONYM_NAME
>------------------------------ ------------------------------
>TABLE_OWNER TABLE_NAME
>------------------------------ ------------------------------
>DB_LINK
>----------------------------------------------------------------------------
>----
>
>PUBLIC DBMS_APPLICATION_INFO
>SYS DBMS_APPLICATION_INFO
 ^^^
It looks like this is a script that should be run as SYS. I once tried to run a SYS script as SYSTEM, and I barely lived to tell about it. Do the comments at the beginning of the .sql file tell you what to run it as?

(Apologies if you were SYS and Oracle's just being silly...)

Good luck,
- Catherine

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net

Received on Thu May 24 2001 - 18:13:16 CDT