SQL$HELP72.HLB  —  CREATE  DATABASE
    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
Environment Format Arguments Examples
Close Help