Directs the BUILD utility to build the indexes only.
By default, if you do not specify what is to be built, both indexes and constraints are built.
Directs the BUILD utility to build all indexes (clustered and non-clustered). If ALL is not specified, only non-clustered indexes will be built.
Directs the BUILD utility to build referential constraints only.
By default, if you do not specify what is to be built, both indexes and constraints are built.
Directs the BUILD utility to build both indexes and relationships. BOTH is the default.
Specifies the table for which indexes and/or constraints are to be built.
The name of the schema that defines the table.
The identifier of the table.
Directs the BUILD utility not to validate referential constraints.
If you specify NO VALIDATE, you will have to execute the VALIDATE utility before you can use the table(s).
By default, the validation is performed.
You can specify NO VALIDATE only for a complete BUILD.
Directs the BUILD utility to send a message to the operator whenever a specified number of records are processed.
The message states the phase and step currently being executed and the number of records that have been processed.
The number of records to process before sending a message.
When errors are detected, directs the BUILD utility to either continue processing or stop after a specified number of errors are detected.
By default, processing is stopped after the first error is detected.
Detected errors are listed in the report generated by the BUILD utility.
When errors are detected in the validation process, directs the BUILD utility to either continue processing or stop processing after a specified number of errors are encountered.
By default, processing is stopped after the first error is detected.
Detected errors are listed in the report generated by the BUILD utility.
You can specify VALIDATE ERRORS only for a complete BUILD.
Directs the BUILD utility to either continue when any errors are detected, or stop after a specified number of errors are detected.
By default, processing is stopped after the first error is detected.
Detected errors are listed in the report generated by the BUILD utility.
The number of errors to detect before stopping.
If you are doing a complete BUILD, you can specify different values for error-count for different kinds of errors.
Indicates that processing should continue regardless of the number of errors detected.
Directs the BUILD utility to perform only the nth step of the index or constraint building process.
By default, if you do not specify a step, all four steps are performed as a single operation, and this is considered a complete BUILD.
Directs the BUILD utility to perform only STEP1 of the BUILD process. STEP1 sweeps the area containing the specified table(s), creating an intermediate work file. The file contains the information needed later to build the index structures.
If you specified the EXTRACT option in STEP1 of the LOAD utility, you do not need to run BUILD STEP1.
In this case, the intermediate work file (SYS003) that is output from the LOAD utility can be used as the input file (SYS002) to STEP2 of the BUILD utility.
Directs the BUILD utility to perform only STEP2 of the BUILD process. STEP2 determines the database key of the referenced table rows.
Directs the BUILD utility to perform only STEP3 of the BUILD process. STEP3 creates the index structures needed for both indexes and constraints.
Directs the BUILD utility to perform only STEP4 of the BUILD process. STEP4 updates the prefix(es) of the affected referencing table rows.
|
Copyright © 2014 CA.
All rights reserved.
|
|