Skip to Content
Former Member
May 06, 2005 at 05:33 AM

Views in Oracle DB not seen thru DBConnect


Has anyone come across a situation where a View created on an Oracle DB is not seen thru DB Connect ?

I have views created on an Oracle DB, which can be confirmed independently via pl/sql. When I establish link between a SAP BW and the Oracle DB using a DB Connect, (-intention being to extract data from the Oracle DB into the BW) I dont seem to see some of the views. I am trying to repeat the case to see if there is an issue with 'Grant Access' on the Oracle side. Any ideas ?