3 Replies Latest reply: Oct 20, 2008 9:14 AM by 461680 RSS

    oaiimport for interconnect

    517976
      Hi

      I ran oaiimport from the repository which i took dump from oaiexport.

      It is running from almost one hour and still showing message as

      'Importing ICHUB's objects to ICHUB...'

      Does it take that much time to complete?.. and what message will i get once it gets completed..

      Thanks
      Sun
        • 1. Re: oaiimport for interconnect
          554596
          HI
          please check the steps to be followed before doing oaiimport and after oaiimport.
          It may take long time to import if there is lot of data in tables.

          if the export is done properly and If there are thousands of records in oai_agent error table or any other table in the export taken from oai hub.It takes long time for oai import.
          • 2. Re: oaiimport for interconnect
            461680
            ...... If there are thousands of records in oai_agent error table or any
            other table in the export taken from oai hub.It takes
            long time for oai import.

            You can safely truncate the oai_agent_error table prior to oaiexport (assuming you are going from dev -> test ->prod

            You might need to review the errors if you are going the other way
            • 3. Re: oaiimport for interconnect
              461680
              If you are running against a 10.2 database then you may experience this problem. Edit the oaiimport script and modify the ORACLE_HOME and PATH to point to your 10.2 ORACLE_HOME.