hi,Ehresmann, David please check your os kernel parameters ? it looks like that the process can not operator on a large file which is biger than 131071 blocks (1G ?). Best regards yahoo id: feng_chunpei A new dba from china ---- from the mail----- > >Has anybody seen this error before, and yes I have read all over metalink. >This is a new dev db 9.2.0.4.0 on aix 5.1L, copied from a prod db. It has >6gb of undo tablespace. The original prod db is 8i and had 12 gb of >rollback. This error is generated from a 3rd party product that basically >inserts into tables in the app schema. I have checked the limits on the OS >with the admin and they are unlimited for oracle. This error is not >consistent. Some times it does not happen at all. And it will reference >different datafiles, i.e. undotbs01.dbf, undotbs02.dbf, ... The 3rd party >product uses a unix account, should its limits be unlimited? Or is it just >the size of the undo tablespace? > > >ORA-00604: error occurred at recursive SQL level 1 >ORA-01116: error in opening database file 54 >ORA-01110: data file 54 '/.../.../.../undotbs03.dbf' >ORA-27092: skgfofi: size of file exceeds file size limit of the process >Additional information: 131071 >Additional information: 256001 > > >thanks, > >David Ehresmann >---------------------------------------------------------------- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >---------------------------------------------------------------- >To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx >put 'unsubscribe' in the subject line. >-- >Archives are at //www.freelists.org/archives/oracle-l/ >FAQ is at //www.freelists.org/help/fom-serve/cache/1.html >----------------------------------------------------------------- > >. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------