Database Reference
In-Depth Information
Figure 11-4.
Syntax of the Create-Database Statement (continued)
Observation:
In some systems, database creation is as simple as creating a directory
(library or folder depending on the operating system used). Unfortunately, this is not the
case in Oracle. For more details on this matter, see the Oracle Product Documentation
[Oracle, 2008].
11.3 Database Management
Once the database has been created, it must be populated with database objects. Database
objects include tablespaces (specific to Oracle), tables, indexes, views, synonyms,
procedures, triggers, packages, sequences, users, roles, etc. As a good DBA and/or software
engineer, you will also need to carry out performance tuning on your database.
This may involve reorganizing database tables and indexes, deleting unnecessary indexes
or moving other objects. You will also be required to periodically perform backup and
