6 Replies Latest reply: Feb 6, 2013 5:26 PM by 826118 RSS

    EXPDP : ORA-01031: insufficient privileges

    826118
      Hi,

      When I add the QUERY clause in the parameter file, get the following errors.

      ERROR :
      ORA-31693: Table data object "TESTDB"."ACCOUNT" failed to load/unload and is being skipped due to error:
      ORA-01031: insufficient privileges

      Verison : Export: Release 10.2.0.4.0 - 64bit Production

      Parameter :

      DIRECTORY=USER_DATA_PUMP_DIR
      CONTENT=ALL
      PARALLEL=4
      ESTIMATE=STATISTICS
      INCLUDE=TABLE:"IN(SELECT EXP_TABLE_NAME FROM EXPDP.EXP_TABLES)"
      QUERY=TESTDB.ACCOUNT:"WHERE ADDED_OPRID NOT IN (SELECT OPRID FROM EXCLUDE_OPRID)"
      FLASHBACK_TIME = "to_timestamp(to_char(sysdate,'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS')

      Following grants were created on the EXPDP export datapump user.

      GRANT EXP_FULL_DATABASE TO EXPDP
      GRANT "CONNECT" TO EXPDP
      GRANT CREATE SESSION TO EXPDP
      GRANT CREATE TABLE TO EXPDP
      GRANT SELECT ANY TABLE TO EXPDP

      Can you help me to resolve this issue?

      Thanks,