Charity wrote:
> 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
Check the docs at http://tahiti.oracle.com for restrictions.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Nov 20 2007 - 15:00:40 CST