Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

export from 10g

758410May 25 2010 — edited May 25 2010

Hello experts,

facing some problem with export from 10g in windows2003.did the folowing steps....

1.created a separate user for export
2.ghranted export and import privs

and while exporting the full database error as ....

C:\oracle\product\10.2.0\db_1\BIN>expdp expdpadmin/expdp full=y directory=sys_dm
p dumpfile=full_db_expdp.dmp logfile=full_db_expdp.log

Export: Release 10.2.0.1.0 - Production on Tuesday, 25 May, 2010 10:01:05

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

any help....

thanks,

This post has been answered by MsJ on May 25 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 22 2010

Added on May 25 2010

#general-database-discussions

18 comments

2,460 views