3 Replies Latest reply on Nov 18, 2019 9:52 AM by 3348111

    DBMS_DATAPUMP.OPEN  "privileges are required"  error

    3348111

      Hi,

      I have one PDB that belongs to the Application Container.

      In that PDB there I have created a user :

       

      CREATE USER PUMPUSER IDENTIFIED BY PWD1 DEFAULT TABLESPACE TBL_TEST QUOTA UNLIMITED ON TBL_TEST;

      grant UNLIMITED TABLESPACE, CREATE SESSION, CREATE TABLE, CREATE JOB to PUMPUSER;

      grant DATAPUMP_IMP_FULL_DATABASE to PUMPUSER;

       

      PUMPUSER then has created one dblink called DBLINKTEST....which works fine.

       

      when PUMPUSER connects and call  DBMS_DATAPUMP.OPEN..

       

      DBMS_DATAPUMP.OPEN(

                    operation => 'IMPORT',

                    job_mode => 'FULL',

                    remote_link => 'DBLINKTEST..',

                    job_name => 'myjob');

       

      I am getting the following error:

       

      rror report -

      ORA-31631: privileges are required

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79

      ORA-06512: at "SYS.DBMS_DATAPUMP", line 4932

      ORA-06512: at "SYS.DBMS_DATAPUMP", line 6844

      ORA-06512: at line 4

      31631. 00000 -  "privileges are required"

      *Cause:    The necessary privileges are not available for operations such

                 as: restarting a job on behalf of another owner, using a device

                 as a member of the dump file set, or ommiting a directory

                 object associated with any of the various output files.

                 Refer to any following error messages for additional information.

      *Action:   Select a different job to restart, try a different operation, or

                 contact a database administrator to acquire the needed privileges.

       

       

      My problem is that I am not able to find which privilege exactly is missing. I tried to add some more, beside mentioned, but not of help.

      Please any idea how I can make this running. ?