Toad Pocket Reference for Oracle, 2nd Edition

90

|

Toad Pocket Reference for Oracle

Creating and Altering Objects

Toad’s Create and Alter dialogs help DBAs to manage their

database objects. For example, you can quickly create a roll-

back segment from Toad’s Create menu or from the Roll-

back Segments Schema Browser tab. This section describes

objects you can manage if the DBA Module is present.

Create new objects

You can use the Create dialog available from the Create

menu to quickly create a database object without having to

worry about syntax or typographical errors.

The Create/Alter dialogs are fully fleshed out to display all of

the DDL options supported by Oracle (options not available

and activated are greyed out). The dialogs are smart enough

to detect the Oracle version you are connected to and to

enable/disable the appropriate options. Figure 20 shows a

portion of the menu invoked by selecting DBA

➝ Create.

If you have a role in one instance, you can use the handy

Schema Browser function, Create Like, to create the same

role in another instance. You can even modify the script that

will be executed if you want to tweak the role you are moving.

Alter existing objects

You can use Toad’s Alter dialogs to make a change to an

existing object. You can access these directly from the

Schema Browser or, if you are querying an object in an edi-

tor and you need to modify or examine the object(s) at hand,

you can simply place your cursor on the object ...