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

Hi,

this table (and some others) contains the P-code for your stored procedures (and from 7.3 your triggers). Import is probably trying to compile the trigger but couldn't insert the result into this table. This table and especially the tables IDL_UB1$ and IDL_UB2$ can become pretty large , if you have a lot of stored procedures.
I would not change the storage parameters for these tables as they normally are OK. Your system tablespace is probably too small so I would try to increase the size of it first (if you have the diskspace). You could try to change the storage parameter (by alter table ... storage (next ..), but try increasing the size of system first.

Rgds
Steinar Heggelund

RYoung (ryoung_at_summer.dbsol.com) 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 Wed Mar 19 1997 - 00:00:00 CST