Re: Export Backup Failure

From: Sreejith S Nair <Sreejith.Sreekantan_at_ibsplc.com>
Date: Wed, 11 May 2011 16:35:06 +0530
Message-ID: <OF07915BB0.56559074-ON6525788D.003CD489-6525788D.003CE4A1_at_ibsplc.com>



A search in MOS gives this link, Did you check this - ORA-68 During Export After Applying CPU Patch [ID 382162.1]

HTH,
Sreejith

From: Nagaraj S <nagaraj.chk_at_gmail.com> To: oracle-l <oracle-l_at_freelists.org> Date: 05/11/2011 04:10 PM

Subject:        Export Backup Failure
Sent by:        oracle-l-bounce_at_freelists.org



Hello,  

Export backup faling with below error. Kindly help here.    

 Export: Release 10.2.0.1.0 - Production on Wed May 11 00:00:54 2011  Copyright (c) 1982, 2005, Oracle. All rights reserved.

 Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
 With the Partitioning, OLAP and Data Mining options  EXP-00056: ORACLE error 68 encountered
 ORA-00068: invalid value 1000000 for parameter sort_area_size, must be between 7801677937 and 3819475968

 ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 720
 ORA-06512: at line 1
 EXP-00056: ORACLE error 68 encountered
 ORA-00068: invalid value 1000000 for parameter sort_area_size, must be 
between 7801677937 and 3819475968
 ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 720
 ORA-06512: at line 1
 EXP-00000: Export terminated unsuccessfully
 

-Nagaraj

DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."

--

http://www.freelists.org/webpage/oracle-l Received on Wed May 11 2011 - 06:05:06 CDT

Original text of this message