Re: Problem with SYS.IDL_SB4$ ? Error on import?

From: Stephen Miller <stepmil_at_ibm.net>
Date: 1997/03/17
Message-ID: <332E019F.8D7@ibm.net>#1/1

This error indicates that you have run of space in your SYSTEM tablespace. ORACLE is trying to allocate an extent of 315 blocks (if your blocksize is 4096 bytes, this represents 1,260K of space). You have a number of alternatives:

You can increase the size of SYSTEM by adding a new data file (using ALTER TABLSPACE system ADD DATAFILE...).
It is possible that you are not really out of space in SYSTEM, but just don't have an extent that is at least 315 blocks long. Check the dictionary view SYS.DBA_FREE_SPACES to find out if you have any extents left. If you do, you can change the size of the NEXT extent for this table with an ALTER TABLE SYS.IDL_SB4$ STORAGE (NEXT somevalue) ;
I don't recognize this table, so it is possible that it is a temporary table created by the import process or by the failing trigger. In that case, you don't want this table in SYSTEM, but rather in a temporary tablespace. You achieve this by altering your import user's TEMPORARY TABLESPACE to something other than SYSTEM.

Hope this helps

Stephen Miller

RYoung wrote:
>
> I received this error during an import of an export file to an Oracle 7.3
> database. . I thought maybe I could drop this table, and redefine it with
> larger parameters, but since it is a sys table I am reluctant to try this,
> as well as the fact the exp will not export the table. It has an
> 'undefined' datatype for one row (see below) which export says it does not
> support. Any ideas how I can get the rest of the import to go in correctly?
> Increasing the size of the system tablespace was already tried with no
> success.
>
> You help is appreciated in advance
>
> Log of import follows...
>
> ""
> IMP-00003: ORACLE error 604 encountered
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01653: unable to extend table SYS.IDL_SB4$ by 315 in tablespace SYSTEM
> IMP-00017: following statement failed with ORACLE error 604:
> "CREATE TRIGGER "APPS".AR_RATE_ADJUSTMENTS_BRI BEFORE INSERT on
> AR.AR_RATE_A"
>
> --
>
> Table definitions
>
> SQL> describe SYS.IDL_SB4$;
> Name Null? Type
> ------------------------------- -------- ----
> OBJ# NOT NULL NUMBER
> PART NOT NULL NUMBER
> VERSION NUMBER
> PIECE# NOT NULL NUMBER
> LENGTH NOT NULL NUMBER
> PIECE NOT NULL UNDEFINED
>
> ____________________________________________________
> Robert Young
> rcyoung_at_summer.dbsol.com
> "Standard disclaimer for employee views..."
Received on Mon Mar 17 1997 - 00:00:00 CST