OBJECTSET specification for REBUILD INDEX
The OBJECTSET specification is shown in REBUILD-INDEX-syntax.
OBJECTSET creator.name
The following rules apply to creator.name:
- creator specifies the name of the creator of the group and can have up to 128 characters in length.
- name species the group name and can have up to 128 characters in length.
- You can delimit both creator and name with single or double quotation marks.
- Both creator and name can contain the special characters $, #, and @ in any position.
BMC AMI Recover uses dynamic grouping to determine the group contents at the time that you run the BMC AMI Recover job containing the OBJECTSET option. Because BMC AMI Recover reads the objects in the group each time the job is executed, objects might be added or removed from the group.
Following are restrictions that apply when you use OBJECTSET with REBUILD INDEX:
- AUX is ignored with any specification of OBJECTSET.
- You cannot specify PART with OBJECTSET. BMC AMI Recover uses the group definition for the object.
- You cannot use INDEP INTABLESPACE with OBJECTSET.
- You cannot use TABLESPACE with OBJECTSET.
EXCLUDE (dbname.ts or qualifier.ix) | Use the EXCLUDE option after an OBJECTSET specification to exclude one or more objects from the rebuild. You can use wildcards or specific names to specify the exclusions. The following wildcards are valid:
List the excluded objects following the EXCLUDE keyword. Each item in the list must be in the form dbname.ts or qualifier.ix and you must separate the individual items with commas. Enclose the list in parentheses.
|
|---|