Toad World® Forums

Something happening here (ORA-00942)


#1

What it is ain’t exactly clear. L

If in the MOE, I enter

“select * from a_table;”

or

“select count(*) from a_table;”

I’m blessed with “ORA-00942: table or view does not exist “

But if I put the cursor on a_table and press F4, Toad shows me a nice
description of the table. Thus I’m reasonably sure I’m not
misspelling the name. And if I click the ‘Data’ tab, I can see all
the data in a_table.

I realize that Toad is powerful, but all-seeing? Any idea what’s going on
here?

Thanks much,

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323

image001.jpeg


#2

Have you checked that the table F4 shows you is in the same schema as the table
you are trying with the SELECT. The SELECT looks for the table in OWNER that is
running the SELECT. F4 finds the table name in any owner.

Try adding OWNER name to the table name
image001.jpeg


#3

AHA! Right you are. I see that said table is not in my schema. Adding the
rightful owner does do the trick. Thanks much.

So what does Toad-F4 do if the same table name exists in more than one schema?

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323
image001.jpeg


#4

it flies to johannesberg…and kicks the winning goal for england
?
Martin Gainty


Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.

Ce message est confidentiel et peut être privilégié. Si vous n’êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l’expéditeur. N’importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l’information seulement et n’aura pas n’importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.


#5

On Mon, 2010-06-14 at 16:10 -0400, Martin Gainty wrote:

it flies to johannesberg…and kicks the winning goal for england
?

And blows into a vuvuzela. Wow are those things annoying. Why can’t the
broadcasting team filter out that part of the audio?

Joseph Charpak
josephcharpak@comcast.net


#6

Morning,

And blows into a vuvuzela. Wow are those things annoying.
Why can’t the broadcasting team filter out that part of the audio?
Or even better, filter out the whole competition and put something worth
watching on?

Cheers,
Norm. [TeamBanFootball]

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


#7

Martin,

it flies to johannesberg…and kicks the winning goal for england?
Oh please no! The last time they actually won it (1966 in case no-one
has mentioned it yet!) was 44 years ago and still it gets a mention each
and every time anything is happening with Engerland in it. The USA match
for example, 30 seconds into the game and the first mention of 66 came
up. I don’t know if they have noticed but since 1966 lots of “third
world” South American countries have won it far more often.

And does anyone know what this is all about? It has to be a spoof
doesn’t it? http://i.imgur.com/YDjND.jpg

Anyway, my English team won at the weekend. McLaren F1 (only slightly
New Zealand though!).

Cheers,
Norm. [TeamHateFootball]

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


#8

Morning Dan,

So what does Toad-F4 do if the same table name exists in
more than one schema?
It looks, if I remember correctly, to build a list of tables/objects in
your schema, then in other schemas, then synonyms. Then displays the
details of the first one in the list. You can see what exactly it does
if you spool the sql or run SQL Monitor. Makes for interesting bedtime
reading!

I think I reported this as a “bugette” many years ago because I was
seeing a similar problem to you and it was driving me bonkers! I
personally think that F4 should stick to user_tables, user_objects, then
user_synonyms, then all_tables, all_objects and all_synonyms (or
something like that!) and if it finds anything in any of these, stop
looking.

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