# Something happening here (ORA-00942) **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [June 14, 2010, 2:41pm UTC](https://forums.toadworld.com/t/something-happening-here-ora-00942/9612 "2010-06-14T14:41:35Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [June 14, 2010, 2:41pm UTC](https://forums.toadworld.com/t/something-happening-here-ora-00942/9612/1 "2010-06-14T14:41:35Z")
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](https://global.discourse-cdn.com/quest/original/2X/e/e116b4c84f27bd77fd3220f8a4f05f089f0a582f.jpeg) ---
**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\ **Post date:** [June 14, 2010, 2:52pm UTC](https://forums.toadworld.com/t/something-happening-here-ora-00942/9612/2 "2010-06-14T14:52:16Z")
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](https://global.discourse-cdn.com/quest/original/2X/e/e116b4c84f27bd77fd3220f8a4f05f089f0a582f.jpeg) ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [June 14, 2010, 2:59pm UTC](https://forums.toadworld.com/t/something-happening-here-ora-00942/9612/3 "2010-06-14T14:59:02Z")
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](https://global.discourse-cdn.com/quest/original/2X/e/e116b4c84f27bd77fd3220f8a4f05f089f0a582f.jpeg) ---
**Author:** ![MGainty](https://avatars.discourse-cdn.com/v4/letter/m/a5b964/32.png) [@MGainty](https://forums.toadworld.com/u/MGainty)\ **Post date:** [June 14, 2010, 3:10pm UTC](https://forums.toadworld.com/t/something-happening-here-ora-00942/9612/4 "2010-06-14T15:10:44Z")
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. ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [June 14, 2010, 3:42pm UTC](https://forums.toadworld.com/t/something-happening-here-ora-00942/9612/5 "2010-06-14T15:42:14Z")
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](mailto:josephcharpak@comcast.net) ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [June 15, 2010, 1:55am UTC](https://forums.toadworld.com/t/something-happening-here-ora-00942/9612/6 "2010-06-15T01:55:59Z")
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](http://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](http://www.environment-agency.gov.uk) ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [June 15, 2010, 2:04am UTC](https://forums.toadworld.com/t/something-happening-here-ora-00942/9612/7 "2010-06-15T02:04:07Z")
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](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](http://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](http://www.environment-agency.gov.uk) ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [June 15, 2010, 2:25am UTC](https://forums.toadworld.com/t/something-happening-here-ora-00942/9612/8 "2010-06-15T02:25:46Z")
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](http://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](http://www.environment-agency.gov.uk)