I’m a new inventory analyst using TOAD. Nobody around to help much and I have search online for the answer. I have connected to an Oracle DB and the authentication seems to be fine. When I click on the connection expecting something to show up in the object browser I get nothing. Is this a setup issue on my side? or a permissions issue with the DBA who setup my account. TIA-
Ernest
Sorry I forgot…I running TDA Read-Only Version 2.6
When you connect to Oracle the Object Explorer will show you all of the tables in your schema. If you do not have any tables in your schema you will not see anything. Change the schema drop down to the owners of the tables or use the synonyms tab if they are public or private synonyms.
Once you have determined where the tables are that you most commonly use you can create filters to only see them, or set a specific schema as the one to point to when first connecting. See screenshots
Debbie
When you connect to Oracle the Object Explorer will show you all of the tables in your schema. If you do not have any tables in your schema you will not see anything. Change the schema drop down to the owners of the tables or use the synonyms tab if they are public or private synonyms.
Once you have determined where the tables are that you most commonly use you can create filters to only see them, or set a specific schema as the one to point to when first connecting. See screenshots
Debbie
When you connect to Oracle the Object Explorer will show you all of the tables in your schema. If you do not have any tables in your schema you will not see anything. Change the schema drop down to the owners of the tables or use the synonyms tab if they are public or private synonyms.
Once you have determined where the tables are that you most commonly use you can create filters to only see them, or set a specific schema as the one to point to when first connecting. See screenshots
Debbie
that makes perfect sense…and it doesn’t fix my problem…I sent an email to the DBA’s thinking they may have missed a permission somewhere along the way. Thanks for response, it did help clarify some things. I’ll post back if the permissions fix it…thanks
So it turns out in our system for whatever reason there is an “*” at the top of the schema list. choose that and it gives me everything that the system says I have permission for. then I can filter. Very strange. But I’m in and working…
Yay! I forgot about the wild card filter.
Debbie
