1 2 Previous Next 18 Replies Latest reply on Oct 1, 2019 2:27 PM by Dean Gagne-Oracle Go to original post
      • 15. Re: TTS import running long
        Dean Gagne-Oracle

        I don't know anything about APEX.   Sorry

         

        Dean

        • 16. Re: TTS import running long
          3696858

          Dear Dean, no worries, but thanks a lot for helping us, right now we completed migration and requesting out application team for data validation.

           

          Thanks

          • 17. Re: TTS import running long
            3696858

            Dear Dean,

             

            One quick question, while am observing logs, I see below  privilege issues, right now am running impdp with system user grating role "DATAPUMP_IMP_FULL_DATABASE ", but not sure why below..?

             

            Other than above role do I need to give grant create database link to system before running impdp..?

             

             

            ORA-31685: Object type DB_LINK: failed due to insufficient privileges. Failing sql is:

            CREATE DATABASE LINK   CONNECT TO "" IDENTIFIED BY VALUES ':1'  USING ''

            ORA-31685: Object type DB_LINK:failed due to insufficient privileges. Failing sql is:

            CREATE DATABASE LINK   CONNECT TO "" IDENTIFIED BY VALUES ':1'  USING ''

            ORA-31685: Object type DB_LINK:"" failed due to insufficient privileges. Failing sql is:

            CREATE DATABASE LINK ""  CONNECT TO "" IDENTIFIED BY VALUES ':1'  USING ''

             

            Thanks

            • 18. Re: TTS import running long
              Dean Gagne-Oracle

              That is a strange one.   Datapump_imp_full_databaase is granted 'create session' which includes the privs to create public and private database links.  I'm not sure what is happening there.

               

              Dean

              1 2 Previous Next