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
muthu_dba
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
p;

Export: Release 10.2.0.1.0 - 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 10.2.0.1.0 - Produc
tion
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
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
This will help you...
Datapump

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

Or

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 Sep 26 12:51:10 CDT 2016

Total time taken to generate the page: 0.11209 seconds