Creates database system files, metadata definitions, and user
data that comprise a database. The CREATE DATABASE statement
lets you specify in a single SQL statement all data and privilege
definitions for a new database. (You can also add definitions to
the database later.) For information about ways to ensure good
performance and data consistency, see the Oracle Rdb7 Guide to
Database Performance and Tuning.
The many optional elements of the CREATE DATABASE statement
make it very flexible. In its simplest form, the CREATE DATABASE
statement creates database system files, specifies their names,
and determines the physical characteristics of the database.
Using the optional elements of the CREATE DATABASE statement, you
can also specify:
o Whether the database created with CREATE DATABASE is multifile
(separate database root file and storage area data file) or
single file (combined database root file and storage area
data file). Multifile databases can have many storage areas
for user data, all separate from the database root file
created by the CREATE DATABASE statement. Multifile databases
include CREATE STORAGE AREA clauses in the CREATE DATABASE
statement to create multiple storage area files for enhanced
performance.
The presence or absence of a CREATE STORAGE AREA clause in
a CREATE DATABASE statement determines whether the database
is single file or multifile. To create a multifile database,
you must include a CREATE STORAGE AREA clause in the CREATE
DATABASE statement. To create a single-file database, do not
include a CREATE STORAGE AREA clause in the CREATE DATABASE
statement.
o Values for various database root file parameters that override
the system defaults. Database root file (.rdb) parameters
describe characteristics of the database root file. Database
root file parameters affect the entire database, whether it is
a single-file or a multifile database.
o Values for storage area parameters that override system
defaults. Storage area parameters describe characteristics of
the database storage area files. In a single-file database,
because the storage area data file is combined with the
database root file, storage area parameters apply to a single
storage area and affect the entire database. In a multifile
database, storage area parameters specify defaults for the
main storage area, RDB$SYSTEM, and for any subsequent CREATE
STORAGE AREA clauses within the CREATE DATABASE statement.
o Any number of database elements. Database elements are a
CREATE CATALOG statement, a CREATE STORAGE AREA clause, or
a GRANT statement. The CREATE DATABASE statements that create
single-file databases cannot include a CREATE STORAGE AREA
clause because this is specific to multifile databases. The
CREATE DATABASE statements that create multifile databases
must include at least one CREATE STORAGE AREA clause.
Unlike the same statements outside a CREATE DATABASE
statement, database elements do not use statement terminators.
The first statement terminator that SQL encounters ends the
CREATE DATABASE statement. Later CREATE or GRANT statements
are not within the scope of the CREATE DATABASE statement.
o The database default character set and national character set.
For information regarding identifier character sets, database
default character sets, and national character sets, see the
Character_Sets HELP topic.
Additional Information:
explode
extract