The file specification associated with the database.

    You can omit the FILENAME clause if you specify the ALIAS clause.
    If you omit the FILENAME clause, the file specification uses the
    following defaults:

    o  Device: the current device for the process

    o  Directory: the current directory for the process

    o  File name: the alias, if any was specified; otherwise omitting
       the FILENAME clause generates an error

    Use either a full file specification or a partial file
    specification.

    You can use a logical name for all or part of a file
    specification.

    If you use a simple file name, SQL creates the database in the
    current default directory. Because the CREATE DATABASE statement
    may create more than one file with different file extensions, do
    not specify a file extension with the file specification.

    The file specification may contain an OpenVMS remote node
    specification. Oracle Rdb must be installed on that remote node
    so that the CREATE DATABASE statement can be executed remotely.
    Note that all other file specifications in the command (storage
    areas, snapshot files, recovery journal location, and so on) must
    be specified using the logical names and device names relative to
    that remote node.

    The number and type of files created using the file specification
    in the FILENAME clause depend on whether you create a multifile
    or single-file database.

    o  In multifile CREATE DATABASE statements (any that include
       CREATE STORAGE AREA clauses), SQL uses the file specification
       to create up to three files:

       -  A database root file with an .rdb file extension

       -  A storage area file, with an .rda file extension, for the
          main storage area, RDB$SYSTEM, (unless the CREATE DATABASE
          statement contains a CREATE STORAGE AREA RDB$SYSTEM clause,
          which overrides this file specification)

       -  A snapshot file, with an .snp file extension, for the
          main storage area, RDB$SYSTEM (unless the CREATE DATABASE
          statement contains a CREATE STORAGE AREA RDB$SYSTEM clause,
          which overrides this file specification)

    o  In single-file CREATE DATABASE statements (any that omit the
       CREATE STORAGE AREA clause), SQL uses the file specification
       to create two files:

       -  A combined root and data file with an .rdb file extension

       -  A snapshot file with an .snp file extension

       If you create a single-file database, you cannot later create
       additional data and snapshot files with ALTER DATABASE . . .
       ADD STORAGE AREA statements. If you want to change a database
       from a single-file to a multifile database, you must use the
       EXPORT and IMPORT statements.