Toad Pocket Reference for Oracle, 2nd Edition

6

|

Toad Pocket Reference for Oracle

Note the following Toad basics:

• In Toad, Oracle rules. Toad never violates, restricts, or

enhances the Oracle privileges and permissions that have

been defined for you. Toad does not affect your defined

relationship to your Oracle instance in any way.

• Toad is closely integrated with Oracle. The Toad editor

has the ability to execute nearly all SQL*Plus commands

(except certain DBA commands such as STARTUP and

SHUTDOWN).

• Toad has numerous window- and panel-specific right

mouse menus. Check everywhere to see if a right mouse

menu is available.

Installing and Configuring Toad

Toad has a wizard-driven installation with options for local,

network, and Citrix installation. You will be prompted to

choose options such as whether to use tabs or a tree-style

Schema Browser, whether to run the Unix scheduler scripts,

and so on. After the install is complete, you can always mod-

ify the default configuration from View

➝ Options.

TIP

The basic Toad install does not require that any objects

be installed in your Oracle instance.

Expanding Toad’s Functionality

Once you have installed Toad, you can choose to expand its

basic functionality by selecting Tools

➝ Server Side Objects

Wizard. This installs objects needed for running Explain

Plans and using the Stored Program Profiler, Toad Security,

and Team Coding facilities. You can install these objects into

a selected schema or allow