Check the following: You must have SELECT access on the Space Manager tables and on DBA_TABLESPACES TOAD schema must have the privileges to create and alter jobs, create and drop its own tables a...
An email to the Beta group went as follows: From: toadbeta@yahoogroups.com [mailto:toadbeta@yahoogroups.com] On Behalf Of Brad Boddicker Sent: Thursday, April 30, 2009 10:22 AM To: toadbeta@yahoogrou...
You can search for various metacharacters in the MOE as follows : CTRL F (or Edit→Find) to open the Find dialogue. Tick the box marked Regular expressions in the Options section. In the Text to...
One from Wendy Penfold on the Toad lists: Hi, I need to load a large file of insert statements–44,000. The file is too large to open in the Toad editor, it hangs Toad. Is there a way I can run the sc...
set echo off set heading off set feedback off SPOOL c:\temp\all_tmp.sql select 'alter user ' || username || ' temporary tablespace TEMP;' from dba_users where temporary_tablespace != 'TEMP'; SPOOL off...
Check to see whether you have an object named the same as the owner of the procedure. When this is the case, Oracle thinks that the user name in the anonymous block is actually the object name. We rec...
Q: When I describe a table (say hit F4 on the table name in a SQL query) I often like to copy and paste Column Names from the Columns tab into a SQL statement – however when i do paste it, the column ...
What I'm trying to pin down is how accurate the execution time displayed in TOAD is. For some complex queries, the time displayed may be 1 second. If I trace the query using TKPROF it reports about 4 ...
In Toad for Oracle 11.6, go to Options | Editor | Execute/Compile in the solution below. For earlier versions: Sometimes you have to use version control to ensure that you have a full history of what...
Q: What is FastReports? A: FastReports is the report engine in Toad that allows for custom and dynamic reporting against live data sets. FastReports is included with the standard edition of Toad for ...
To resolve these problems, go to Edit → Editor Options and look under "General Options", under the "General Options" node, where there are several options related to tab stops. Unchecking "Auto indent...
Q: How to import data from an Excel file into a table? A: See Toadworld blog post "Create and Load Oracle Tables from Excel Spreadsheet using Toad“ Q: I have a flat file (.csv, tab delimited, etc.)...
