Toad Week Toad Strong (a 3-Arrrgh issue)

Hello,
Today is a three-arrgh Friday (see below).
Luckily, there is help for what ails thee.
[ToadThumbsUp.png]

Toad Week
Toad Strong
Weekly tips to strengthen your use of Toad


  Toad for Oracle


(c) Copyright 2012, all rights reserved



Archived Issues
(single PDF): ToadForOracle.com<http://toadfororacle.com/entry.jspa?externalID=4972&categoryID=391>.
Lots of links and info to help you use Oracle well by using Toad well.

Favorite from the List
"I know it's not Friday, but arrrgh anyway!"

Reason for "arrrgh:"
"When I try to run the SQL*Loader Wizard with a control file that works fine for a colleague, I get the following message:
Message 2100 not found; No message file for product=RDBMS,
facility=ULMessage 2100 not found; No message file for product=RDBMS,  facility=UL
Loader is finished.
The ctl file and INFILE, etc. are all accessible to me on the same network drive that my colleague uses.
Any ideas why she's so lucky?"
[http://s3images.coroflot.com/user_files/individual_files/featured/featured_264909_w1i0uM64Mi0rFYQpG1gSRPzKj.jpg]
TurrellArt.com
Most Helpful Answer?

A.      "Sounds like your setting for ORACLE_HOME is trashed. Could be registry, could be in Windows itself. That's the usual cause of 'Message xxxxx not found' errors."

B.       "Don't forget that when things like this occur you can choose the three dots button [NITR_ellipsis.png]  on the Toad connection window next to Oracle Home to open the Home Selector  / Correction Utility - or you can run Oracle's Home Selector - both can/will fix such issues and save the re-install."


And in response to last week's Quick Describe item:
"Ctrl/D looks nice, but I think I'll be sticking [https://encrypted-tbn3.google.com/images?q=tbn:ANd9GcQUDV2JYiE_kTXCqVOtMWjj4kSnYbC1zmbV8AjX52LjgeBkM6dr] with F4.
F4 can 'figure out' what object I'm looking at (have my cursor on); Ctrl/D cannot."
Good to know - thanks Dan! :)
Tipsy Toad
Share your favorite tips. Email me<mailto:[email protected]?subject=Tipsy%20Toad> with "Tipsy Toad" in the subject line. [cid:[email protected]]









Still Reading?<mailto:[email protected]?subject=Tipsy%20Toad>
Get back to work so you can go home! ;-)







July 20, 2012
Updates, tips, questions and answers.
Beta<https://twitter.com/wordpressdotcom> Development Update
ClearCase

If you are an IBM Rational ClearCase customer, please let us know. Stephen is looking for folks to assist him with config issues.

Project Lucy
Feedback greatly appreciated

This release - Project Lucy GUI overhaul.
Important: To see this update, right-click on the toolbar and click Restore Defaults.

  *   Moved from Database | Monitor

     *   To Database | Diagnose.

  *   Added Project Lucy launch point from the Database Browser.


64-bit

Still missing XLS component (Excel support), and working on getting EurekaLog 7 fixed.

Localized Reports

..have been located into several languages. More news on this soon.

ToadWorld

You'll believe it when you see it, right? We are working to update what is already a very active user community to an ever better format.

...and stay tuned for something very exciting (Repository)


Go team!
>>> Remember, now you can go to:
Help | Toad Online | New in This Release for Developers' notes and instructions.
Do you use Oracle Wallet or External Authentication?
[Idea Pond]Idea Pond idea #558 spells this out.
"Toad supports external authentication. To log in that way (assuming it is set up in the DB), you can just specify the my_tns_entry in the Database field of the login window, and leave username/password blank."

-          Leave User/Schema and Password blank,

-          Fill in the Database field,  and click OK.
"Wow! This is great news. Apparently this is documented in the Help under "OPS$ Accounts", so now my Idea is simply to add information to the documentation indicating that this method can be used with an Oracle Wallet."
Done! :) ...in the next GA release.
New Toadies
[cid:[email protected]]
You were new once, too, and look at you now
[NITR_OPTIONS_135_2_Options.png]
Take five minutes to learn more about Toad options.
On the toolbar:

-          Click the 'Configure TOAD options' icon [NITR_OPTIONS_135_2_Options.png]  or View | Toad Options.

-          See Toolbars/Menus | Shortcuts in the Options window.

-          Learn how to create your own shortcuts in the Customize Shortcut Keys topic in Help.
Did you know there is a Search field at the bottom of the Options window?
Pass it on.
Power Users

Who are our power users? You are!

From an internal list:

"The real way to move data from some other database into Oracle is to extract the data from the source into a text file and then use Oracle's SQL*Loader (Toad for Oracle has a wizard). Relying on a cross join or multi platform database toll will be far inferior to doing extract and SQL Load ...."
Dev Team
Good information in this exchange (excerpt):
Toad User 1:
I always, always, always hit <ctrl>+Enter to execute SQL.  All of a sudden today I try it and it's opening a pop-up Editor window?

Toad User 2:
"Arrr! That be no bug, me lads and lassies, that be a feature!
-          If you're executing a SQL statement in the context of what Toad sees as PL/SQL, it tries to scan the SQL for bind variables, then scan the rest of the code to find the values for those variables and substitute them in.
-          It then presents the result to you to confirm that it got it right (or correct it), and then it will execute the SQL."

Toad Developer:
"Arrrr! You beat me to it!
I'll add that you should look at the SQL in the Edit SQL dialog.
-          Has it been modified in any way (other than formatting)? If so, what are the modifications? Are they correct?
-          The feature compares unknown identifiers to a long list of built-in routines so that items like TO_CHAR, SYSDATE, etc. are not converted into a bind unexpectedly.
-          It also changes references to your own functions into bind variables and comments out the original call so you can reinstate it if desired.
In some cases function calls may be inaccessible from outside of a package, or in other cases the function modifies data which would be undesirable when just testing the standalone SQL.
In other cases, you may want the function call to get an accurate plan.
Without being able to anticipate all needs, I've opted for the safe approach of commenting out function calls and leaving the original commented.
Michael"

Good on ya!
(I assume.)
-Donna

Source of the future-looking toad photo; we (Greg) took the liberty of adding sunglasses because you are all so cool.: www.digitalcinemareport.com/Sundance-Cane-Toads-Barco-Dolby<http://www.digitalcinemareport.com/Sundance-Cane-Toads-Barco-Dolby>