Database Administration (MOSC)

MOSC Banner

SYS.DB_OBJECT_CACHE PKG ORA-00913: too many values

edited Aug 5, 2013 2:49AM in Database Administration (MOSC) 9 commentsAnswered
hello guru,
    I upgraded my database from 10.1.0.5 to 11.2.0.3.3 then I see this next error :
SYS.DB_OBJECT_CACHE PKG ORA-00913: too many values.

thanks for your help.
Jean-Pierre

I executed this next and i do not understand very good what I have to execute.

alter package sys.DB_OBJECT_CACHE_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> select count(*) from dba_objects where status='INVALID';

COUNT(*)
----------
4

SQL> show error
Errors for PACKAGE BODY SYS.DB_OBJECT_CACHE_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
14/3 PL/SQL: SQL Statement ignored
14/15 PL/SQL: ORA-00913: too many values
SQL> select text from dba_errors where name ='DB_OBJECT_CACHE_PKG' and owner='SYS';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center