| Export in Datapump [message #436231] |
Tue, 22 December 2009 04:48  |
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  |
 |
ramoradba
Messages: 2456
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 
[Updated on: Tue, 22 December 2009 05:01] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
