SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  ADD_STORAGE_AREA
    Specifies the name and file specification for a storage area you
    want to add to the database. You can use the ADD STORAGE AREA
    clause only on multifile databases. The storage area name cannot
    be the same as any other storage area name in the database.

    The ADD STORAGE AREA clause creates two files: a storage area
    file with an .rda file extension and a snapshot file with an
    .snp file extension. If you omit the FILENAME argument, 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 name specified for the storage area

    The file specification is used for the storage area and snapshot
    files that comprise the storage area (unless you use the SNAPSHOT
    FILENAME argument to specify a different file for the snapshot
    file, which you can only specify with a multifile database).
    Because the ADD STORAGE AREA clause creates two files with
    different file extensions, do not specify a file extension with
    the file specification.

    If you use the ALTER DATABASE statement to add a storage area,
    the change is journaled, however, you should back up your
    database before making such a change.
Close Help