I had a very similar problem a while back. Look at patch # 3352413 on metal ink. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Spears, Brian Sent: Tuesday, December 13, 2005 2:23 PM To: oracle-l Subject: export error for duh Gurus Has anyone got ideas or run across this intermittent export error? Randomly getting this error in the export full. Metalink does not show anything related at our version so a tar created. . . exporting table CARTON_STATUS EXP-00008: ORACLE error 8103 encountered ORA-08103: object no longer exists . . exporting table CLASS_IMPLEMENTATION 33 rows exported * oracle 10.1.0.3.0 Hpux 11.23 32bit 9000/800 * The table exists * The error occurs on different tables each time * Check for block corruption shows no problems * table creation date is months back * normal processing in the database at this time * consistent=y, direct=y full=y rows=y Brian Spears _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Yongping Yao Sent: Tuesday, December 13, 2005 1:22 AM To: sjaffarhussain@xxxxxxxxx Cc: oracle-l Subject: Re: pga_aggregate_target I think Expert Oracle: Database Arichitecture Chapter 3 (or 4 I don't have it in hand) will help you. On 12/13/05, The Human Fly <sjaffarhussain@xxxxxxxxx> wrote: Hello List, I was little confused about the settings of pga_aggregate_target parameter. I was in a assumption that when we set this parameter to a certain value, the usage of pga wont go beond this value. I have set pga as 3gb to one of my business critical database. Recently, I have found that max pga allocation was 4+ Gb. My boss askmed me, why the hell it takes more than what we have defined. I explained him saying that oracle might taken it from the OS to finish the necessary request. His immediately counter question was, then what is the use of setting pga_aggregate_target parameter? When oracle allocates and de-allocated the memory (pga) as per requirements. Is it expected behaviour that oracle takes sometime more that the value defined for pga? If so, what is the benift of setting value for pga? Thanks for your time. -- Best Regards, Syed Jaffar Hussain OCP 8i & 9i DBA, Banque Saudi Fransi, Saudi Arabia ------------------------------------------------------------------------ ---------- "Winners don't do different things. They do things differently." -- //www.freelists.org/webpage/oracle-l -- Yao Yongping Learning Oracle, UNIX/Linux... Love Reading, Classical Music, Philosophy, Economics etc. Blog: http://spaces.msn.com/members/yaoyp/ This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.