RE: Export Backup Failure

  • From: Mohammad Rafiq <rafiq9857@xxxxxxxxxxx>
  • To: <nagaraj.chk@xxxxxxxxx>, oracle list <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 12 May 2011 20:52:59 -0400

Has anybody revoked execute privilege from public for 
SYS.DBMS_EXPORT_EXTENSION. If yes, then it should be granted to exporting user 
including system. 
 


Date: Wed, 11 May 2011 16:09:51 +0530
Subject: Export Backup Failure
From: nagaraj.chk@xxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx


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
                                          

Other related posts: