2 Replies Latest reply: Jul 1, 2010 1:41 AM by 653212 RSS

    ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings

    630404
      hi experts i m facing ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings error while importing schema level backup the have below proviliges
      CREATE USER T24EXP
      IDENTIFIED BY VALUES 'A8BE03AC28E87FE6'
      DEFAULT TABLESPACE USERS
      TEMPORARY TABLESPACE TEMP
      PROFILE DEFAULT
      ACCOUNT UNLOCK;
      GRANT CONNECT TO T24EXP;
      GRANT RESOURCE TO T24EXP;
      GRANT EXP_FULL_DATABASE TO T24EXP;
      GRANT IMP_FULL_DATABASE TO T24EXP;
      ALTER USER T24EXP DEFAULT ROLE ALL;
      GRANT UNLIMITED TABLESPACE TO T24EXP;

      GRANT READ, WRITE ON DIRECTORY SYS.DMP_EXP TO T24EXP;
      GRANT READ, WRITE ON DIRECTORY SYS.DUMP_BKUP TO T24EXP;
      GRANT READ, WRITE ON DIRECTORY SYS.SIT_DMP_EXP TO T24EXP;


      what is the possible reason of getting this error
        • 1. Re: ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings
          Hoek
          Maybe you need to:
          grant import full database to T24EXP;


          ORA-39122: Unprivileged users may not perform string remappings.
          Cause: A user attempted to remap objects during an import but lacked the IMPORT_FULL_DATABASE privilege.
          Action: Retry the job from a schema that owns the IMPORT_FULL_DATABASE privilege.
          http://download.oracle.com/docs/cd/E11882_01/server.112/e10880/e38001.htm#sthref11940
          • 2. Re: ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings
            653212
            I also faced same problem.
            After putting both datapump_exp_full_database & datapump_imp_full_database i could not remap schema & tablespace (I think IMPORT_FULL_DATABASE not a privilege it should be IMP_FULL_DATABASE ).
            To resolve the problem I grant DBA to the user. (I think this is reasonable to give enough power to get access on other's schema & tablespace).

            If anybody has better solution please inform.


            -Obaid