A list of DB objects through ODBC&client tool dialog versus objects seen in USER_OBJECTS view?
Hello,
Trying to provide SPSS or Office Spreadsheet access to the Ora (11gR2 ) database directly through ODBC connection based on Oracle client 11.2.0.5.
In the step of dialogue where db objects are presented in the list for selecting object there are many objects. And selecting from such list seems as very strenous action because the list is very long. And dialoge has no option for filtering.
But when I look in SQL+ or SQL developer in the user_objects view ( connected on same user as it was used in ODBC connection ) I get only one object.
I was sure that in client tools like ODBC dialogue box in MS QUERY only objects from user_objects are presented.