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!

Retrieving APPS Schema from OTHER database instance

Discussion in 'Other Databases' started by bhavakrish, Apr 27, 2010.

  1. bhavakrish

    bhavakrish Guest

    Dear Friends,


    I need one great help, Presently I am engagged one portal project the requirement is, I need to retrieve ORACLE APPS schema tables (like per_people_f) from other local Database Instance (X)

    I have created one DB link at X, and retrieved information from APPS schema but some tables required session information at APPS schema itself. Thus certain tables returms 0 rows.

    Please help me.

    Thanks
    Bhava Krish
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Why are you not exporting this schema from the source database? Export/Import or Data Pump might be much better options over this 'query over a db link' method.