Specifies the name of the default directory to which row
    cache backing file information is written. The database system
    generates a file name (row-cache-name.rdc) automatically for each
    row cache backing file it creates when the RCS process starts up.
    Specify a device name and directory name enclosed within single
    quotation marks ('); do not include a file specification. The
    file name is the row-cache-name specified when creating the row
    cache. By default, the location is the directory of the database
    root file.

    The LOCATION clause of the CREATE CACHE, ADD CACHE, or ALTER
    CACHE clause overrides this location, which is the default for
    the database.

    This clause is ignored if the row cache is defined to checkpoint
    to the database.