Skip to Content
Former Member
May 13, 2011 at 11:40 PM

Getting the data from other schema in the same database



I have a report that has few subreports. Some times some of these sub reports retreives the data from the same table in different schema.

ex: if I have table TEST on both schema A and B, and I use A.TEST in my report, but it get the data from B.TEST when I had login as user A.

Do anybody have any idea what is going on here. I use CR XI and Oracle 10g.

Thanks and appreciate any help.