Library /sys$common/syshlp/RDOHELP72.HLB  —  DEFINE_DATABASE, Format  file-spec
    A file specification that names the database file. You should use
    either a full file specification, including device, directory,
    and file name without the file type, or a simple file name. In
    the second case, Oracle Rdb creates the database in the current
    default directory. In a single-file database, the file name
    specified becomes the file name for two files:

    o  The database file. The default file type is RDB.

    o  The snapshot file. This file is used as a temporary file for
       read-only transactions. The default file type is SNP.

    Type the name of the file-spec in uppercase letters when you
    define your database if you use the data dictionary or may
    use it in the future. If you type the name of the file-spec in
    lowercase letters and try to use the DEFINE GENERIC command of
    the dictionary's CDO utility to create a directory name for the
    database in the dictionary, the command will fail.

    In a multifile database, the file name specified becomes the file
    name for three files:

    o  The database root file. The default file type is RDB.

    o  The default storage area file. The default file type is RDA.

    o  A snapshot file. The default file type is SNP.
Close Help