Toad for Oracle Archives

Toad

Why do members of a redo log show up red in the redo log manager? I show no Oracle errors in the alert log and I do see that oracle is using the log.

By Steve Hilker | October 31, 2012

If the entry is red, then either the redo log size does not match the size of the other redo logs or there is a missing file. The count of the members should be the same across all the groups....

Read →

Toad

Why don’t I see any jobs for Space Manager?

By Steve Hilker | October 31, 2012

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...

Read →

Toad

Unicode Support in Toad 10

By Steve Hilker | October 31, 2012

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...

Read →

Toad

Toad for Oracle – How do I search for special characters (metacharacters) in the editor?

By Quest Software | October 31, 2012

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...

Read →

Toad

Toad for Oracle Editor – How to Run Very Large Scripts

By Quest Software | October 31, 2012

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...

Read →

Toad

Toad for Oracle Editor – How can I use TOAD to create and run dynamic SQL?

By Quest Software | October 31, 2012

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...

Read →

Toad

Toad for Oracle – When I try to run my procedure through the debugger, I get an error that says “PLS-00201: identifier … must be declared”.

By Steve Hilker | October 31, 2012

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...

Read →

Toad

Toad for Oracle – Table description

By Steve Hilker | October 31, 2012

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 ...

Read →

Toad

Toad for Oracle – What does the execution time in the sql editor actually represent?

By Steve Hilker | October 31, 2012

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 ...

Read →

Toad

Toad for Oracle – Preventing users compiling database objects under version control

By Steve Hilker | October 30, 2012

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...

Read →

Toad

Toad for Oracle – FastReports Q&A

By Steve Hilker | October 30, 2012

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 ...

Read →

Toad

I’m having problems with tab stops. They’re not consistent, and when I open a file created in Toad for Oracle in another editor, the spacing is all uneven.

By Steve Hilker | October 30, 2012

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...

Read →

Listing Page