Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem running .sql scripts for upgrade
"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 DBAReceived on Mon Apr 25 2005 - 04:27:27 CDT