RE: Export Backup Failure

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_at_gmail.com
To: oracle-l_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
                                               

--

http://www.freelists.org/webpage/oracle-l Received on Thu May 12 2011 - 19:52:59 CDT