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