Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem running .sql scripts for upgrade

Re: Problem running .sql scripts for upgrade

From: <sybrandb_at_yahoo.com>
Date: 25 Apr 2005 02:27:27 -0700
Message-ID: <a1d154f4.0504250127.6e24c5fe@posting.google.com>


"mike_sap" <Mike.Zecky_at_gmail.com> wrote in message news:<1114411216.809824.149930_at_z14g2000cwz.googlegroups.com>...
> Hi Everyone!
> I am having big trouble running sql scripts. I am into upgrade from
> 8.1.7.4.1 to 8.1.7.4.12. In the procedure in the patch readme file its
> been told to run scripts with following names through follwoing
> directories.
> @utlgdk.sql
> @prvtgdk.sql
> @prvtbfla.plb
> @catexp.sql
> @catproc.sql
>
> When I run I am getting following errors.
> SVRMGR> @prvtgdk.plb
> CREATE OR REPLACE LIBRARY utl_gdk_lib wrapped
> *
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01653: unable to extend table SYS.IDL_SB4$ by 13 in tablespace
> SYSTEM
> CREATE OR REPLACE PACKAGE BODY utl_gdk wrapped
> *
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01653: unable to extend table SYS.IDL_SB4$ by 13 in tablespace
> SYSTEM
>
> Any help or guidance as to how solve this problem is highly
> appreciated.
>
> Thanks in advance.
>
> Mike

Please read the error messages carefully. They are saying you are running out of space in the tablespace SYSTEM. Resize the datafile associated with the tablespace SYSTEM or put it on autoextend.

--
Sybrand Bakker
Senior Oracle DBA
Received on Mon Apr 25 2005 - 04:27:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US