Database Reference
In-Depth Information
Figure 11-3.
BNF Notation Symbols
11.2 Database Creation
In the Oracle environment, database creation is quite involved, requiring you to be aware
of several intricate details about the Oracle DBMS itself. A database may be created in
one of three ways: manually, using the Database Configuration Assistant (DBCA), or
during installation of the Oracle Database server software. In each case, the
Create-
Database
statement is employed (manually or automatically). However, there are certain
procedures and intricate details which have to be carefully observed. In the interest of
getting you started, these intricacies will be de-emphasized for now. Below (Figure
11-4
)
is the syntax of the
Create-Database
statement, followed by a simple example.
Figure 11-4.
Syntax of the Create-Database Statement
