Re: package STANDARD not accessible

From: James Keeley <jkeeley_at_monsanto.com>
Date: Tue, 12 Feb 2002 09:11:54 -0000
Message-ID: <3c68dd34@primark.com>

"Trifon Anguelov" <trifona_at_pacbell.net> wrote in message news:P7H88.1694$Hn7.985578624_at_newssvr21.news.prodigy.com...
> James,
>
> From svrmgrl connect as internal and run:
> - catalog.sql (for data dictionary)
> - catproc.sql (for stored packages)
> - utlrp.sql (to recompile invalidated objects)
>
> Hope that helps,
>
> Trifon Anguelov
> Senior Oracle DBA
>

Thanks Trifon. catalog.sql seems to run fine, but I'm getting many errors running catproc.sql along the lines of:

CREATE OR REPLACE PACKAGE BODY dbms_prvtaqip wrapped *
ORA-00604: error occurred at recursive SQL level 1 ORA-01652: unable to extend temp segment by 41 in tablespace SYSTEM Received on Tue Feb 12 2002 - 03:11:54 CST