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

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

Mohan Kumar Newbie
Currently Being Moderated

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points