Home » RDBMS Server » Server Utilities » Export in Datapump (10G 2.0, Windows)
Export in Datapump [message #436231] Tue, 22 December 2009 04:48 Go to next message
Messages: 17
Registered: December 2009
Location: Bangalore
Junior Member
I performed the Export operation using this command and got error like this. Can anyone solve this?

F:\>expdp hr/hr dumpfile=hr_full.dmp logfile=hr_full.log full=y directory=exp_bu

Export: Release - Production on Tuesday, 22 December, 2009 4:07:35

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release - Produc
With the Partitioning, OLAP and Data Mining options
ORA-31631: privileges are required
ORA-39161: Full database jobs require privileges
Re: Export in Datapump [message #436233 is a reply to message #436231] Tue, 22 December 2009 04:58 Go to previous message
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
This will help you...

39161, 00000, "Full database jobs require privileges"
// *Cause:  Either an attempt to perform a full database export without the 
//          EXP_FULL_DATABASE role or an attempt to perform a full database
//          import over a network link without the IMP_FULL_DATABASE role. 
// *Action: Retry the operation in a schema that has the required roles.

similar faq


Too easy to understand

sriram Smile

[Updated on: Tue, 22 December 2009 05:01]

Report message to a moderator

Previous Topic: External Tables - Tab Separated Values
Next Topic: Directory problem
Goto Forum:

Current Time: Mon Jun 21 18:36:40 CDT 2021