TOAD® Handbook

Creating, Altering, and Managing Database Objects

Probably the most common task any DBA does is to create, alter, and otherwise manage database objects. For example, the typical DBA might perform daily routine tasks such as:

• Add a new data file to a tablespace
• Modify a data file to increase its size
• Create a new rollback segment
• Create a new database role
• Grant a role or privilege to a role
• Create a new database user
• Grant a role or privilege to a user
• Create a table and some indexes on it
• Add or drop columns from a table
• Add a new constraint to a table
• Add a new index to a table
• Create a new view definition

In fact, the complete list of routine DBA tasks is almost endless, such that the preceding list merely attempts to show the ...