3 Replies Latest reply: May 26, 2011 1:03 PM by 757707 RSS

    exclude schema grants - impdp

    user12075620
      Hi Experts,

      I am getting the following error during import using impdp

      Failing sql is:
      GRANT SELECT ON "CM_DBA"."PARTY" TO "CM_USR"
      ORA-39083: Object type OBJECT_GRANT failed to create with error:
      ORA-01917: user or role 'CM_USR' does not exist
      Failing sql is:
      GRANT SELECT ON "CM_DBA"."PARTY_RLN" TO "CM_USR"


      How to exclude CM_USR during import in windows?


      Thanks for the help.

      Regards,
      Richard