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.