All_Segments
Noall_Segments
The All_Segments qualifier specifies that RMU Repair should
retrieve all segments of a segmented string; the Noall_Segments
qualifier specifies that RMU Repair should only retrieve the
first segment of a segmented string.
Specify the Noall_Segments qualifier if you know that the list
storage map for any segmented strings stored on the specified
areas might have contained multiple areas. For example, if the
storage map was created using the following SQL command, Oracle
Rdb would store all the segmented strings on AREA1 until AREA1
became full. If AREA1 became full, Oracle Rdb would continue to
write the rest of the segments into AREA2. Suppose AREA2 becomes
corrupt. In this case, retrieving the first segment from AREA1
is not sufficient; all segments must be retrieved to determine if
part of the segmented string is missing.
CREATE STORAGE MAP FOR LIST STORE IN (AREA1, AREA2) FOR (TABLE1)
IN RDB$SYSTEM;
Specifying the Areas qualifier and the All_Segments qualifier
is unnecessary and redundant because specifying the All_Segments
qualifier causes RMU Repair to check all storage areas regardless
of where the segmented string was stored initially.