The CREATE_PK_IN_DOC procedure accepts the following optional parameters.
| Parameter | Description |
|---|---|
| PARALLEL | The degree of parallelism to use while creating the primary key
constraint and 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 destination table 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 source table. The default value is defined in the DEFAULT_INDX_TS_NAME column of the IN_DB_UPGRADE_CONTROL_SYNC table. |