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...
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...
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...
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....
This example shows how to load a script into SQL*Plus for the current session and execute it: Go into PM Options → Associations Remove SQL as an extension for SQL Editor (or anywhere else it may ...
Determine your ORACLE_HOME value. The first thing to check is the ORACLE_HOME value. Examine the following key in your Windows registry: HKEY_LOCAL_MACHINE\Software\ORACLE There should be an entry fo...
An undocumented (well, up until the help file for Toad 10.6 anyway ) way to trace the amount of time various startup routines take is to edit your TOAD.INI file and add some or more of the following l...
The tablespace map uses a simplified fragmentation formula. The key points in question: What is the 'sum of the blocks for that segment'? SELECT sum(blocks) FROM dba_extents WHERE tablespace_nam...
Q: Escaping the '_' Character: How do I escape out the '_' character in a query? A: The _ is a wildcard for any single character. You must specify the escaping within the SQLstatement itself. Here's ...
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...
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 ...
