This discussion is archived
3 Replies Latest reply: Oct 20, 2008 7:14 AM by 461680 RSS

oaiimport for interconnect

517976 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    ...... 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 Newbie
    Currently Being Moderated
    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.