Database Utilities (MOSC)

MOSC Banner

A list of DB objects through ODBC&client tool dialog versus objects seen in USER_OBJECTS view?

edited Oct 8, 2014 10:02AM in Database Utilities (MOSC) 6 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center