RDOHELP72.HLB  —  CHANGE_STORAGE_MAP, More
    To change a storage map for a relation with the CHANGE STORAGE
    MAP statement, you need the Oracle Rdb CHANGE privilege for the
    relation.

    If the database is created with the DICTIONARY IS REQUIRED
    option, you must invoke the database by path name, rather than
    file name, before you issue this statement.

    You must specify either a store-clause, a [NO]PLACEMENT VIA INDEX
    clause, a REORGANIZE clause, or a COMPRESSION clause in a CHANGE
    STORAGE MAP statement.

    In the change-relation-map-clause, you can select one or more of
    the three clauses ([NO]PLACEMENT VIA INDEX clause, REORGANIZE
    clause, or COMPRESSION clause) in any order, but you cannot
    repeat a clause. Note that when the REORGANIZE clause is used,
    records are moved and assigned to new dbkeys.

    If you omit the store-clause in the CHANGE STORAGE MAP statement,
    you can create a second index by mistake.

    You must execute this statement in a read/write transaction.
    If there is no active transaction and you issue this statement,
    Oracle Rdb starts a read/write transaction implicitly.

    Other users are allowed to be attached to the database when you
    issue the CHANGE STORAGE MAP statement. However, they are not
    allowed to be using the relation whose map is being changed.
Close Help