I have installed TOAD and spent hours upon hours trying to figure out how to display any objects more specifically Tables from an Oracle database. I can find no way in this software to actually access anything in the db. The really sad part of all of this is so far MSAccess is better for connecting to an Oracle db than TOAD. I have found TOAD to be completely non functional. Lots of buttons with descriptions of what you could do if the product worked.
I can tell you are frustrated. Sorry to hear that. The product works well.
I’m not sure what the problem is but I’ll be happy to help.
I’m going to start very basic:
Step 1: Start Toad
Step 2: Make a connection (near the right side of the toolbar – a plug
button with a blue +)
Step 3: Open the schema browser (2nd toolbar button)
Once in the schema browser, you may need to change to a schema that owns tables.
This is the dropdown with the user name in it.
MS Access may actually be showing you views. You’ll find lots of them in
the SYS schema.
If you want to see what tables you have access to in the database, open up the
Editor (first toolbar button). Type in:
Select owner, table_name
From all_tables
Then hit F9.
Owner is the same as schema name.
Morning Terry,
I have installed TOAD and spent hours upon hours trying to
figure out how to display any objects more specifically
Tables from an Oracle database.
You need the schema browser to see them in a GUI, or, as John has
already advised, run a query in the editor to select the tables from
ALL_TABLES - which will show you all the tables your schema owns plus
all the tables, owned by other schemas, that your schema has access to.
I can find no way in this software to actually access anything in the
db.
What exactly is it that you want to do in the database?
The really sad part of all of this is so far MSAccess is better for
connecting to an Oracle db than TOAD.
I respectfully disagree. Both connect quite happily to an oracle
database. When you run queries, Toad passes exactly what you type to
the database, Access passes (via ODBC) exactly what it thinks that you
should have types. They are not necessarily the same. (Unless, in
Access, you use pass-through queries of course, in which case, Access
and Toad both send exactly what you typed to the database.)
I have found TOAD to be completely non functional.
I strongly disagree. As I asked above, what exactly are you wishing to
do?
How long have you used Toad for?
How long have you used Oracle? (not via Access, but using other Oracle
"native access" tools such as SQL*Plus)
Lots of buttons with descriptions of what you could do if the product
worked.
Toad works, trust me, I make a living from using it daily. Toad works so
well in fact that Oracle themselves have tried (and failed) to create a
"Toad Killer" application.
Off the top of my head, it sounds to me as if you are possibly connected
to a database where you have no objects, or permissions to see or create
objects. Even Access can't help you there.
Talk to me off-line, if you wish, my private email is toad "at"
dunbar-it "dot" co "dot" uk, and I'll try to help.
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
I am not a DBA but perhaps you have some configuration issues. If you
aren’t set up correctly or don’t have the permissions, you
won’t be able to see TOAD’s functionality – of which there is
a wide array. Possibly a good old fashioned operator error rather than a product
deficiency? Maybe someone can step you through the set up.
Darlene R. Ulmet
Financial Analyst II
Decision Support Services
Baylor Health Care System
Phone: (214) 820-1936
Fax: (214)820-8284
Email: Darlene.Ulmet@BaylorHealth.edu
I am not a DBA but perhaps you have some configuration issues. If you
aren’t set up correctly or don’t have the permissions, you
won’t be able to see TOAD’s functionality – of which there is
a wide array. Possibly a good old fashioned operator error rather than a product
deficiency? Maybe someone can step you through the set up.
Darlene R. Ulmet
Financial Analyst II
Decision Support Services
Baylor Health Care System
Phone: (214) 820-1936
Fax: (214)820-8284
Email: Darlene.Ulmet@BaylorHealth.edu
Wonder if Oracle client is set up correctly? Seem to remember MSAccess was able
connect to Oracle db w/o using Oracle Client software. And if you are not admin
on your PC getting the Oracle Client to work correctly can be a bear – at
least in our environment it is, where the temp settings and permissions are
problems.
Deborah M Flad, DBA
Office: 302.633.2694 Emergencies: 302.528.3652
“Please consider your environmental responsibility before printing this e-mail”
Actually your comments make you appear for all intents and purposes to be an arrogant ass.
TOAD has very little capability to do complex queries due to the inherit structure in the application. Those would be queries with multiple joins and multiple embedded queries. Of course I’m sure you can write them in your sleep, since you seem to be the self proclaimed god of all things Oracle.
Unfortunately, MSAccess does outperform TOAD in every environment we have tested over the past two months. MSAccess really doesn’t like to communicate with Oracle.
Thanks for your help. We found the problem(s) after trying a lot of different things. There wasn’t any problem with Oracle or the workstations. We did finally get it to work.
Unfortunately it really isn’t an improvement over MSAccess.
Let’s dial It back a bit folks, this forum is setup to help people. If you
can’t play nice, you’ll be booted.