1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Import Portal

Discussion in 'General' started by mzainal, Aug 14, 2009.

  1. mzainal

    mzainal Forum Advisor

    Messages:
    72
    Likes Received:
    0
    Trophy Points:
    130
    Hi,

    I'm doing import portal in db from other server. But i getting this error.

    Code (Text):
    Error: Transport Set is in use on the target
    How to fix this error?
     
  2. mzainal

    mzainal Forum Advisor

    Messages:
    72
    Likes Received:
    0
    Trophy Points:
    130
    The error has been solve. I delete in portal schema.

    But the other problem is when i run imp for import table, it hangs. Export/import with same database version and portal server.

    [​IMG]
     
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,532
    Likes Received:
    361
    Trophy Points:
    1,430
    Location:
    Aurora, CO
  4. mzainal

    mzainal Forum Advisor

    Messages:
    72
    Likes Received:
    0
    Trophy Points:
    130
    The link that you give not helping me at all. Any idea? Still stuck there.:eek:

    When i check in DB dev, there are more than 20000 rows on WWUTL_DOC_TX_DOCUMENT$ table.
     
  5. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,532
    Likes Received:
    361
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You have not reported what v$session_wait lists as the major wait events for that particular session, a question I asked in the same post where the link was given. Have you not investigated those waits? If not, why not?
     
  6. mzainal

    mzainal Forum Advisor

    Messages:
    72
    Likes Received:
    0
    Trophy Points:
    130
    From the v$session_wait, i saw so many event waiting their turn. Maybe they forgot to take a ticket i guess. :D
     
  7. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,532
    Likes Received:
    361
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    If you are not familiar with the Oracle wait interface then possibly you should ask about it. Have you run a Statspack/AWR report while you are running this import? You ask questions for which you are unprepared to supply additional, necessary information so how can you expect others to provide useful answers?

    Generate a Statspack or AWR report and post the results so others can see what might be blocking this import.