The CREATE_INDEXES_IN_DOC procedure accepts the following optional parameters.
| Parameter | Description |
|---|---|
| MAX_MINUTES | The maximum number of minutes that the procedure is permitted to
start new operations. When greater than 0, the parameter is used to set
an end time that defines when the procedure can no longer pick up new
work. This parameter helps to limit the amount of work that the
procedure is permitted to perform to help scope operations within a
limited timeframe. If MAX_MINUTES is greater than 0 then a check will take place to determine if time (MAX_MINUTES) has expired before creating the next index on the list. The default value is defined in the DEFAULT_MAX_MINUTES column of the IN_DB_UPGRADE_CONTROL_UPGRADE table. The default value of 0 is equal to unlimited which means the procedure will continue running until all the indexes have been created. |
| PARALLEL | The degree of parallelism to use while creating the indexes on the
destination table. The default value is defined in the DEFAULT_PARALLEL column of the IN_DB_UPGRADE_CONTROL_UPGRADE table. The default value of 0 is equal to CPU_COUNT-2. |
| LOGGING | Used to define whether the index operations are logged (LOGGING) or
not logged (NOLOGGING). If shipping archived redo logs for replication,
then use LOGGING otherwise NOLOGGING will improve performance. Note that with the NOLOGGING option, the indexes will not be recoverable until successfully backed up. The default value is defined in the DEFAULT_LOGGING column of the IN_DB_UPGRADE_CONTROL_UPGRADE table. The default value is LOGGING. |
| TABLESPACE_NAME | The name of the tablespace to create the indexes in. The user must
have a sufficient quota on the tablespace. If not specified, the default value is based on querying MAX(TABLESPACE_NAME) from ALL_INDEXES for the IN_DOC table. The default value is defined in the DEFAULT_INDX_TS_NAME column of the IN_DB_UPGRADE_CONTROL_SYNC table. |