RE: export error for duh Gurus

Brian, do you get the error on conventional exports?  And to be clear I
take it you are using the traditional exp utility and not the new expdp
utility that is the preferred utility with 10g to use for exports.
 
-- Mark D Powell --
 


________________________________

        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Spears, Brian
        Sent: Tuesday, December 13, 2005 4: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."
                --
                http://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/

Other related posts: