2 Replies Latest reply: Feb 9, 2014 11:02 AM by rp0428 RSS

    Not able to access apps table in non apps environment using database link

    Mohan Kumar

      Hi,

       

      I am working on my old legacy system, I want to access apps schema table in non apps environment, I have three table and able to access one tables data in non apps environment using database link but not able to access other two tables data using same database link,

       

      I am able to access below table in non apps environment using below database link

      select * from xx_received_applications@APPS.WORLD 

       

      but not able to access below tables in non apps environment using same database link

      select * from cs_incidents@APPS.WORLD 

      select * from cs_incident_statuses@APPS.WORLD

       

      Please let me know how can I access above two tables data in non apps environment.