Re: Q: Data pump export error ORA-39127 unexpected error from call to export string

On Nov 20, 12:46 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Charity wrote:
> > 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
>
> 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
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -

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 Received on Tue Nov 20 2007 - 13:40:22 CST