SOLVED
Missing Schemas in Oracle
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Sol_O
6 - Meteoroid
‎06-14-2018
10:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello everyone.
I am connected to an Oracle server. I can see some schemas and able to pull data. However, there are a lot of schemas that are missing. I can see and query all schemas in sql developer using the exact same credentials and settings (port, host name, etc).
I've tried re-installing Alteryx and the oracle instant client driver but to no avail. I've also tried creating several connections and still seeing the same incomplete schemas.
Has anyone encountered this issue? Fixes?
Thanks in advance!
Solved! Go to Solution.
Labels:
- Labels:
- Database Connection
1 REPLY 1
‎06-18-2018
08:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alright, this has been resolved. Privilege issues with synonyms and physical tables in the schema.
