Library /sys$common/syshlp/RDOHELP72.HLB  —  CHANGE_DATABASE, Format  change-storage-area-clause  WRITE_ONCE
    You can use the WRITE_ONCE option to change a storage area
    containing stable segmented string data to a format that can
    be stored on a write-once, read-many (WORM) optical disk. A WORM
    optical disk offers a relatively inexpensive way of storing large
    amounts of data for read-only access compared to other storage
    media.

    The following restrictions apply to the WRITE_ONCE option:

    o  Note that you cannot write data other than segmented strings
       to a write-once storage area. Oracle Rdb issues an error message
       if you try to create a storage map that stores data other than
       segmented strings in a write-once storage area. Storage maps
       for non-segmented-string data must be removed before you can
       alter a storage area to WRITE_ONCE.

    o  When you create a storage area on WORM media, you must specify
       that the snapshot area remains on read/write media: do not
       give a snapshot file the WRITE_ONCE attribute.

    o  If you specify the WRITE_ONCE option when storing a segmented
       string, database keys are not compressed. For more information
       on database key compression, see the Oracle Rdb Guide to Database
       Maintenance.

    o  Write-once storage areas do not use SPAM pages to look for
       storage space, but to assist moving data back to non-WORM
       media in which SPAM pages must be built again, space is still
       allocated for them. Since SPAM pages are essential in uniform
       areas, Write-once storage areas cannot be of uniform format
       and therefore are required to be of mixed format.

    o  You can use the PAGE SIZE IS clause of CREATE STORAGE AREA to
       change the default page size for a storage area. To optimize
       storage, always specify an even number of blocks per page.

    o  Rdb does not support magnetic media for storing write-once
       storage areas.

    o  After you move a storage area to or from a WORM device,
       Do a full and complete backup of your database with the
       RMU/BACKUP command and start a new after-image journaling
       file. For more information on backup and recovery procedures
       with write-once storage areas, see the Oracle Rdb Guide to
       Database Maintenance.
Close Help