Hi all,

I cannot find the solution to the following problem after a several
hours of googling. I am using Oracle 10g and trying to export a
database using the data pump. There are a 2 errors that I cannot find
the solutions to. I invoke the export, and it executes fine until:

Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/
OWNER_GRANT/OBJECT_GRANT
ORA-39127: unexpected error from call to export_string :=
SYS.DBMS_RMGR_GROUP_EXPORT.grant_exp(4845,1,...)

It complains for awhile (with additional errors) and then proceeds
with the export. Then has another error
DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX
ORA-39127: unexpected error from call to export_string :=
SYS.DBMS_RMGR_GROUP_EXPORT.grant_exp(4845,1,...)

The export completes and a dump file is produced ... with errors of
course.

The user has full read/write privs on the output directory and also
has full export privs. The database resides on Solaris.

Has anyone seen this behaviour, and what the solution is?

Any help would be GREATLY appreciated.

Much thanks and have a great day!

Charity

Charity wrote:
But does the user have execute on DBMS_RMGR_GROUP_EXPORT?

Granted explicitly or through a role?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Nov 20, 12:46 pm, DA Morgan <damor... (AT) psoug (DOT) org> wrote:
Hi!

I wasn't sure if the user had execute on DBMS_RMGR_GROUP_EXPORT so I
gave it to them explicitly via

grant execute on DBMS_RMGR_GROUP_EXPORT to myuser

And I had the same errors :-(

Thank you for your response!

Charity

Charity wrote:
Check the docs at http://tahiti.oracle.com for restrictions.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org