oracle « SERPland

22May/100

D: Dokumentation TOAD for Oracle (Datenbank Werkzeug)

Quest Software bietet das Datenbank Werkzeug "TOAD" an. Vor allem bekannt- und grossgeworden im Oracle Datenbankbereich. Mittlerweile gibt's neben TOAD for Oracle auch TOAD for mySQL, TOAD for dies und jenes ...

Referenzen
[1] Oracle9i Database Concepts (10g Release 2 (10.2) und höhere Releases
[2] SQL*Plus User's Guide and Reference (Release 10.2) und höhere Releases

Beschreibung:
Bei Toad for Oracle handelt es sich um ein DB Tool (interaktiv und batch), welches erlaubt SQL, PL/SQL und SQL*Plus-Statements gegen eine Oracle Datenbank abzusetzen.
Toad Editionen
----------
Toad for Oracle ist in vier Editionen verfügbar:

Edition Description
Toad™ for Oracle
Provides the foundation and basic tools for Oracle professionals to create and execute queries, as well as build and manage database objects. You’ll benefit from the formatting feature, enhanced user interface and also have support for SQL Plus. This edition enables you to plug into Toad for Oracle's added utilities.

Toad™ for Oracle Professional
(includes all features of Toad™ for Oracle with integrated debugging, PL/SQL knowledge base and code profiling)
Developing PL/SQL code is a lengthy process, requiring a great deal of accuracy. Toad™ for Oracle Professional features an expert code review which effortlessly integrates into Toad for Oracle's Procedure Editor - analyzing stored procedures against a set of rules which means you’ll receive detailed, corrective recommendations.

Für Entwickler ist die Version "Toad™ for Oracle Professional" zu empfehlen

Toad™ for Oracle Xpert
(includes all features of Toad™ for Oracle Professional with integrated SQL Tuning and SQL & PL/SQL Optimization scanning via CodeXpert)
Are you looking for a way to make the chore of tuning SQL code easier and less time-consuming? Toad™ for Oracle Xpert can simplify this task by identifying potential performance limiting factors. We’ve also equipped you with the power of an enhanced SQL Tuning component that is sure to shorten tuning time for developers, DBAs and analysts.

Toad™ for Oracle Suite
The Toad™ for Oracle Suite equips you with all the features and functionality found in Toad™ for Oracle Xpert plus a built-in array of tools to radically improve the way Oracle professionals develop code and build and maintain database objects.
- DBA Module
- Knowledge Xpert™ for Oracle Administration
- Knowledge Xpert™ for PL/SQL
- DataFactory® Developer Edition
- Benchmark Factory® for Databases
- Toad Data Modeler

Für Datenbankadministration (DBA) ist die Version "Toad for Oracle Suite" zu empfehlen
Auf dieser Seite wird die Standardversion "Toad for Oracle" besprochen.

Login TOAD
----------
Für einen Login müssen die folgenden Felder eingegeben werden:
• User / Schema
• Password
• Database (TNS)

Anschliessend kann mit Connect eine Verbindung zur Datenbank hergestellt werden.
Alle bereits verwendeten Connections werden in der Liste links geführt und können dort auch ausgewählt werden.
Nicht mehr benötigte Connections können mit [Del] wieder aus der Liste gelöscht werden.

Bookmark It

8May/100

Quest TOAD 10. ERROR on startup toad.exe: No argument for format ‘%s’

When trying to start up Quest's TOAD, an ERROR occurs:
startup of toad.exe No argument for format '%s'

See EurekaLog 6.0.20

Application:
-------------------------------------------------------
1.2 Name/Description: Toad.exe - (Toad for Oracle)
1.3 Version Number : 10.1.1.8
1.4 Parameters :
1.5 Compilation Date: Mon, 16 Nov 2009 16:36:37 +0200
1.6 Up Time : 4 seconds

Exception:
----------------------------------------------------
2.2 Address : 00412AB5
2.3 Module Name : Toad.exe - (Toad for Oracle)
2.4 Module Version: 10.1.1.8
2.5 Type : EConvertError
2.6 Message : No argument for format '%s'.
2.7 ID : 39BE
2.9 Status : New