Databases Reference
In-Depth Information
10
Chapter
Creating and Maintaining
Database Objects
In This Chapter
Creating relational and external tables
◆
Using Create Table As Select (CTAS)
◆
Creating indexes
◆
Creating views
◆
Using data dictionary and dynamic per-
formance views
◆
As both a DBA and a developer, you will be responsible for creating and
maintaining a variety of database objects. First and foremost, you will be
creating tables. You will also need to know how to create indexes and views.
To keep track of tables, indexes, and other database objects, you can
use data dictionary views, which allow you to retrieve various kinds of
statistics about tables and other database objects.
Two other useful database objects covered here are sequences and
synonyms. Sequences make it easy to generate a series of unique numbers
that are typically used for the primary key of a table. Synonyms facilitate
a consistent naming convention for database objects that may exist in the
user's schema or in another schema of the same database.
Creating sequences and synonyms
◆
