Database Administration (MOSC)

MOSC Banner

error when upgrade to 11g

edited Apr 22, 2009 9:41AM in Database Administration (MOSC) 7 commentsAnswered
 Hi,

When I run catupgrd.sql I got the following error. Please help!

SQL> Rem *************************************************************************
SQL> Rem Remove obsolete Summary Advisor java classes
SQL> Rem *************************************************************************
SQL>
SQL> declare
  2    cursor cur1 is
  3    select owner, nvl(longname, object_name) from
  4         dba_objects, javasnm
  5         where object_type='JAVA CLASS' and
  6               short(+)=object_name and
  7               nvl(longname, object_name) like 'oracle/qsma/%';
  8    l_owner varchar2(30);
  9    l_name varchar2(4000);
 10    l_buf varchar2(4000);
 11    l_restart boolean;
 12  begin
 13    ------------------------------------------------------------------------------
 14    --  We do the outer loop just in case we get a 'snapshot too old' error.
 15    ------------------------------------------------------------------------------
 16    loop
 17      open cur1;
 18 
 19      l_restart := FALSE;
 20 
 21      loop
 22        fetch cur1 into l_owner, l_name;

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