Forum Stats

  • 3,827,527 Users
  • 2,260,790 Discussions
  • 7,897,291 Comments

Discussions

How can I fix the data pump export wizard error in the OBIEE 12c Sample Appliance v607?

Hey there,

I followed the instructions in the link: OBIEE 12c Sample Appliance v607 - Error on starting BI Services in Oracle VM VirtualBox — oracle-tech to start up the OBIEE. In a nutshell, I set the date to 2017 so I can start the OBIEE. Now I want to export the BISAMPLE Schema, as you can see in the following picture. 

Besides, this is the error in the job when I tried to execute the data pump wizard. 

Keep in mind that I don't have access to the internet. Any Ideas? 


Regards, Pascal

Best Answer

  • nabjoshi-Oracle
    nabjoshi-Oracle Posts: 14 Employee
    Answer ✓

    Hi, From which user you are trying to run the export job? make sure that user has assigned with role "DATAPUMP_EXP_FULL_DATABASE"

    you may ask DBA to assign the role.

    command;

    Grant DATAPUMP_EXP_FULL_DATABASE to <USER>;

    GRANT READ, WRITE ON DIRECTORY <DIRECTORY> TO <USER> ;

    Retry after the above.

    Christian Berg-0racle

Answers

  • nabjoshi-Oracle
    nabjoshi-Oracle Posts: 14 Employee
    Answer ✓

    Hi, From which user you are trying to run the export job? make sure that user has assigned with role "DATAPUMP_EXP_FULL_DATABASE"

    you may ask DBA to assign the role.

    command;

    Grant DATAPUMP_EXP_FULL_DATABASE to <USER>;

    GRANT READ, WRITE ON DIRECTORY <DIRECTORY> TO <USER> ;

    Retry after the above.

    Christian Berg-0racle