Allows you to define a new storage area for a multifile database.
To restructure a single-file database to a multifile database,
use the EXPORT and IMPORT statements.
(B)0[madd-storage-area-clause =
qqqq> [4mDEFINE[m [4mSTORAGE[m [4mAREA[m qqqqqqq> storage-area-name qqqqqqqqqqqk
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqqqq> [4mFILENAME[m qqqq> file-spec qqqwqqqqqqqqqqqqqqq>qqqqqqqqqqqwqqqk
mqq> storage-area-options qqj x
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqqqqqqqqqq> [4mEND[m qqqwqqqqqqqqq>qqqqqqqqqqqwq> STORAGE AREA qqqq>
mq>storage-area-name qj
1 – storage-area-name
The name of the storage area you want to create.
2 – file-spec
The file specification for the storage area file. By default,
this file has the default file type RDA.
3 – storage-area-options
(B)0[mstorage-area-options = qwwqqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwwq> xtqq> [4mALLOCATION[m IS qqq> number-pages qqqq>qqqqqqqqq PAGES qqqqux xtqq> [4mPAGE[m [4mSIZE[m IS qqqq> page-blocks qqqqq>qqqqqqqqq BLOCKS qqqux xtqq> [4mPAGE[m [4mFORMAT[m IS qqwqqqq> [4mUNIFORM[m qqqqwqqqqqqqqqqqqqqqqqqqqux xx mqqqq> [4mMIXED[m qqqqqqj xx xtqq> [4mTHRESHOLDS[m ARE q> ( q> val1 wqqqqqqqqqqqqqqqqqqqqwq> ) qqux xx m> ,val2 wqqqqqqqqqwqj xx xx m> ,val3 qj xx xtqq> [4mINTERVAL[m IS qqqqqqq> number-data-pages qqqqqqqqqqqqqqqqqqux xtqq> [4mSNAPSHOT_FILENAME[m [4mIS[m qqqq> file-spec qqqqqqqqqqqqqqqqqqqqux xtqq> [4mSNAPSHOT[m [4mALLOCATION[m IS qqq> snp-pages qqq> PAGES qqqqqqqqux xtwq> [4mSNAPSHOT[m [4mEXTENT[m IS qwqqwq> extent-pages qqqq> PAGES qwqqqux xxmq> [4mEXTENT[m IS qqqqqqqqqqj mq> extension-options qqqqqqqqj xx xmqq> [4mWRITE_ONCE[m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqjx mqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
3.1 – number-pages
The number of database pages allocated to the storage area
initially. Oracle Rdb automatically extends the allocation to handle
the loading of data and subsequent expansion. The default is 400
pages.
3.2 – page-blocks
The size in blocks of each database page. Page size is allocated
in 512-byte blocks. The default is two blocks (1024 bytes). If
your largest record is larger than approximately 950 bytes,
allocate more blocks per page to prevent records from being
fragmented.
3.3 – PAGE_FORMAT
Specifies whether a storage area contains UNIFORM or MIXED pages.
You can use the PAGE FORMAT option with multifile databases
only. In storage areas with uniform page format, all pages in
a specific logical area contain records from the same relation.
In storage areas with mixed page format, pages can hold records
from different relations. The default is uniform.
3.4 – THRESHOLDS
Specifies one, two, or three threshold values. The threshold
values represent a fullness percentage on a data page and
establish four possible ranges of guaranteed free space on the
data pages. When a data page reaches the percentage defined by
a given threshold value, the SPAM entry for the data page is
updated to reflect the new fullness percentage and its remaining
free space.
The default thresholds are 70,85, and 95 percent. If you specify
only one or two values, unspecified values default to 100
percent. You can specify the THRESHOLDS option only on a storage
area for a multifile database. Threshold values can be set for
storage areas with MIXED or UNIFORM storage area page formats.
3.5 – number-data-pages
Specifies the number of data pages between SPAM pages in the
physical storage area file, and thus the maximum of data pages
each SPAM page will manage. The default, and also the minimum
interval, is 256 data pages. The first page of each storage
area is a SPAM page. The interval you specify determines where
subsequent SPAM pages are to be inserted, provided there are
enough data pages in the storage file to require more SPAM pages.
You can specify the INTERVAL option only on a storage area for a
multifile database. The storage area page format must be MIXED.
3.6 – file-spec
Provides a separate file specification for the snapshot file.
Do not specify a file extension other than SNP to the file
specification.
3.7 – snp-pages
Specifies the number of pages allocated for the snapshot file.
The default is 100 pages. You can set the snapshot allocation to
0 pages. In the following cases, you may want to set the snapshot
allocation to 0 pages:
o If you have disabled snapshots. By setting the snapshot
allocation to 0, you may save space.
o If you have changed a read/write storage area to read-only.
The snapshot file is not used, and you can save space by
setting the snapshot allocation to 0 pages.
3.8 – extent-pages
Specifies the number of pages of each extent. The default is 100
pages.
3.9 – extension-options
Specifies the MIN, MAX, and percent growth of each database file
extent. Enclose the parameter list in parentheses.
(B)0[mextension-options =
qqq> ( qqq> [4mMINIMUM[m OF qq> min-pages qqq> PAGES, qk
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqq> [4mMAXIMUM[m OF qq> max-pages qq> PAGES,qk
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqq> [4mPERCENT[m [4mGROWTH[m IS qqq> growth qqqq> ) qqq>
o min-pages
Specifies the minimum number of pages of each extent. The
default is 99 pages
o max-pages
Specifies the maximum number of pages of each extent. The
default is 9,999 pages.
o growth
Specifies the percent growth of each extent. The default is 20
percent growth.