ic3
Reputation: 7690
Discovering tables on an Oracle Database return an empty list
When creating a connection to an Oracle database in icCube 'Select existing DB Tables' is returning an empty list of tables.
The connection is fine and I can query the schema creating SQL queries.
Upvotes: 2
Views: 73
Answers (1)
ic3
Reputation: 7690
The user is used as the schema name, but Oracle uses upper case as default for the schema names. The connection uses the user that is case insensitive.
Just, change the name of your user to the upper case version : USER_1
Upvotes: 2
Related Questions
- Finding a list of table names in the Oracle table DBA_SOURCE
- Show tables returns "Show tables handled."
- Getting all tables from an oracle database
- Not getting list of tables from database
- How can I find the invisible table in oracle 11g?
- Query to fetch table names from dba_tables in oracle
- Oracle 10g - Get list of tables from query i'm executing
- Oracle: query the tables, but no results
- Problems When Querying Oracle Database For List Of Tables: "table or view does not exist"
- Querying tables listed in DBA_Tables