http://www.asktoad.com/DWiki/ 2010-08-10T14:53:38+01:00 http://www.asktoad.com/DWiki/ http://www.asktoad.com/DWiki/lib/images/favicon.ico text/html 2006-07-29T05:27:29+01:00 http://www.asktoad.com/DWiki/doku.php/contact?rev=1154150849 Contact AskToad for questions or comments on this site and it's content. Do NOT use this for Toad sales inquiries or technical questions For Toad Oracle technical questions, new feature requests, or sales information, see the FAQ to contact Que... text/html 2006-03-21T06:02:32+01:00 http://www.asktoad.com/DWiki/doku.php/external_links?rev=1142920952 External Links Website URL TOAD Home http://www.toadsoft.com/toad_oracle.htm Product Features http://www.toadsoft.com/feats.html Version 8.6 Walk Through http://toadsoft.com/get2know86/ Free vs Commercial http://www.toadsoft.com/v... text/html 2006-03-21T06:02:32+01:00 http://www.asktoad.com/DWiki/doku.php/faq?rev=1142920952 questions answers ... text/html 2007-07-26T13:37:23+01:00 http://www.asktoad.com/DWiki/doku.php/howto_ask_questions_the_smart_way?rev=1185457043 While there are no stupid questions, there are better methods in asking one. Thankfully, Eric Steven Raymond and Rick Moen have already shown us the way: How To Ask Questions The Smart Way In a hurry? Microsoft has summarized it for you: How to a... text/html 2006-04-19T11:33:08+01:00 http://www.asktoad.com/DWiki/doku.php/howto_configure_an_oracle_database_to_have_a_self-cleaning_plan_table?rev=1145446388 On the database server, go to $ORACLE_HOME/rdbms/admin copy utlxplan.sql to utlxplan.sql.original - you don't want to lose the original Oracle script. Edit utlxplan.sql and change it to the following : ... CREATE GLOBAL TEMPORARY TABLE PLAN_TABL... text/html 2009-04-17T16:03:46+01:00 http://www.asktoad.com/DWiki/doku.php/howto_configure_toad_for_multiple_users_on_one_pc?rev=1239984226 This applies to version 8.x. It should not be necessary for newer versions. What do you do when you have to share a PC with another TOADie, but you want to maintain separate profiles? This procedure worked for me (assume the two users are John and... text/html 2007-01-19T14:48:35+01:00 http://www.asktoad.com/DWiki/doku.php/howto_create_dblinks_database_links_in_another_schema?rev=1169218115 So, you've decided to create DBLINKs in a few application schemas. As with every other CREATE statement in Oracle 9i+, you'll do this from a DBA account to save some hassle. But when you try to create your first link from your DBA account: CREATE D... text/html 2007-01-25T13:07:10+01:00 http://www.asktoad.com/DWiki/doku.php/howto_debug_plsql_code_that_uses_the_htp_or_htf_packages_to_build_web_applications?rev=1169730430 When using the debugger in TOAD you are able to set various options, paramters etc in a small anonymous block of PL/SQL. While this is fine for non-web oriented PL/SQL code, it doesn't work with Web based code written in PL/SQL when that code makes ... text/html 2008-03-28T07:54:13+01:00 http://www.asktoad.com/DWiki/doku.php/howto_get_a_toad_upgrade?rev=1206690853 Courtesy of Jeff Smith : If you want an upgrade/install from Quest for any Quest product, you need 3 things: A license for the product (in this case Toad for Oracle) To be current on your maintenance contract (automatically included for 1 year a... text/html 2008-03-04T14:50:27+01:00 http://www.asktoad.com/DWiki/doku.php/howto_install_and_update_freetoad?rev=1204642227 After much wailing and gnashing of teeth on the Toad lists at Yahoo with reference to not being able to get the updated FreeToad working, Bert advised the following steps be carried out. Initial, First Time Installation Download the freeware inst... text/html 2008-01-31T09:20:19+01:00 http://www.asktoad.com/DWiki/doku.php/howto_remove_instances_from_the_instance_manager?rev=1201771219 Once you close and open the IM window, you will only see the instances you selected to be monitored. — Norman Dunbar 2008/01/31 09:14 ... text/html 2008-05-16T14:14:19+01:00 http://www.asktoad.com/DWiki/doku.php/howto_report_a_beta_av_problem?rev=1210947259 If you are a member of the Beta testing community and suffer the occasional bout of Access Violation errors then the following is a detailed explanation of how best to report these problems to the developers. The following information is provide by ... text/html 2010-08-03T14:48:33+01:00 http://www.asktoad.com/DWiki/doku.php/howto_see_which_table_a_lob_segment_belongs_to?rev=1280846913 A question asked on the Toad Lists was something like this I remember, I think, that Toad allowed me to see the table or index that a LOB Segment belonged to from within the Database→Administer→Tablespaces Objects tab. For the life of me, ... text/html 2007-03-12T15:13:43+01:00 http://www.asktoad.com/DWiki/doku.php/howto_talk_like_a_pirate?rev=1173712423 For some unknown reason, September 19th each year is "international Speak Like a Pirate" day. Full details are here Now, the guys and girls on the various TOAD lists have taken to Talking Like A Pirate (Typing Like A Pirate?) every Friday... text/html 2010-06-30T19:44:08+01:00 http://www.asktoad.com/DWiki/doku.php/howto_use_toad_over_an_ssh_tunnel?rev=1277927048 Ever had the worry that when you connect to a database to send some data to it, that some eavesdropper on the network might just be waiting to catch all your passwords (Oracle sends passwords in plain text - by default - go figure) and sensitive dat... text/html 2008-08-12T14:06:01+01:00 http://www.asktoad.com/DWiki/doku.php/howto_use_tortoise_svn_with_toad_s_source_control?rev=1218549961 This file gives details of how to get your scripts, packages and so on under version control using SubVersion: specifically, using TortoiseSVN as the GUI - it integrates into Windows Explorer and is accessed via the right-click context menu. There... text/html 2010-08-03T14:47:34+01:00 http://www.asktoad.com/DWiki/doku.php/howtos?rev=1280846854 HOW-TOs Need to upgrade Toad? HOWTO Get A Toad Upgrade. Getting AVs in the Beta? HOWTO report a beta AV problem Need to know how to do something uniquely TOAD? HOWTO Configure TOAD for Multiple Users on One PC HOWTO Configure an Oracle Dat... text/html 2006-07-29T05:24:10+01:00 http://www.asktoad.com/DWiki/doku.php/start?rev=1154150650 AskToad.com is a knowledge-base about Toad Oracle. The main emphasis of AskToad.com is that it's your Toad Oracle KnowledgeBase, like the message at the top of every page here says. AskToad.com can change frequently, so check back often. Better yet,... text/html 2010-08-10T14:53:29+01:00 http://www.asktoad.com/DWiki/doku.php/troubleshooting?rev=1281452009 SQL Monitor is a great little tool that's bundled with Toad starting at or near version 8.0. It is an extremely useful tool to see what statements Toad is generating behind the sceens. To launch SQL Monitor from Toad find the External Tools icon me... text/html 2006-04-03T04:30:08+01:00 http://www.asktoad.com/DWiki/doku.php/wikistats?rev=1144038608 NEW There are 27 users that have generated 226 AskToad Wiki entries on 56 pages. Here are the top contributing users: Hall Of Fame1Rich Jesse3012Norman Dunbar603Bert Scalzo464Mark Lerch175116Matt Wilkins107Ed Klinger9889John Dorlon7104 ...