Assigns the named row cache to the specified storage area. All
rows stored in this area, whether they consist of table data,
segmented string data, or special rows such as index nodes, are
cached if those rows fit in the cache.
If the row cache does not exist, you must create the row cache
before terminating the CREATE DATABASE statement. For example:
SQL> CREATE DATABASE FILENAME test_db
cont> ROW CACHE IS ENABLED
cont> CREATE STORAGE AREA area1
cont> CACHE USING test1
cont> CREATE CACHE test1
cont> CACHE SIZE IS 100 ROWS
cont> ROW LENGTH IS 200 BYTES;
Only one row cache is allowed for each storage area.
NO ROW CACHE is the default for a storage area.