Library /sys$common/syshlp/SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  RECOVERY_JOURNAL_(LOCATION)
    Syntax options:

    RECOVERY JOURNAL (LOCATION IS directory-spec)

    Specifies the location, including device and directory, in which
    the recovery-unit journal (.ruj) file is written. Do not include
    network node names, file names or process-concealed logical
    names. The default is the current user's login device.

    See the Oracle Rdb Guide to Database Maintenance for more
    information on recovery-unit journal files.

    Following is an example using this clause:

    SQL> ALTER DATABASE FILENAME SAMPLE
    cont> RECOVERY JOURNAL (LOCATION IS 'SQL_USER1:[DBDIR.RECOVER]');
Close Help