From: mpir@bellsouth.net (Joe Maloney) Newsgroups: comp.databases.oracle.server Subject: Re: Urgent help required Date: 8 Aug 2001 12:49:46 -0700 Organization: http://groups.google.com/ Lines: 33 Message-ID: References: <9ko2nl$83k$1@ctss92.sgp.hp.com> <9ko83o$l93$1@ctb-nnrp2.saix.net> NNTP-Posting-Host: 199.15.61.5 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 997300187 4444 127.0.0.1 (8 Aug 2001 19:49:47 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 8 Aug 2001 19:49:47 GMT Given the phrases ICD vector, x.sql and y.sql I wonder if we are looking at the remains of an application that has been a-removed or b-not installed properly rather than an Oracle problem, per se. THe SUADM as the package owner also makes me suspicious, leaning to b. Joe Maloney, CSP,CCP,CDP, 07C (thinking maybe I have have enough alphabet soup.) markg@mymail.tm (MarkyG) wrote in message news:... > Check to see who owns the package dbms_application_info (via > all_source view) > , if it is not system, drop the package and recreate under SYSTEM. > Ensure that you have found the right sql script (under > $ORACLE_HOME/rdbms/admin) which relates to dbms_application_info. > > When run under SYSTEM, the correct privileges are given to other users > etc which are not done if erun under any other user. > > Mark (part OCP qualified!) > > > "Billy Verreynne" wrote in message news:<9ko83o$l93$1@ctb-nnrp2.saix.net>... > > "LV" wrote > > > > > When I try to run one of my sql script the sqlplus gives an error > > > Error accessing package dbms_application_info > > > Error: ORA-06509 PL/SQL ICD vector missing for this package > > > > Well, seeing that people like to throw educated guesses and OCP certifications > > around... my uneducated (never did the OCP thing and not planning to) guess is > > that you have not run the catproc.sql to create the PL/SQL side (procedural > > option) of the Oracle data dictionary.