The CREATE_DEST_TABLE_IN_DOC procedure accepts the following optional parameters.
| Parameter | Description |
|---|---|
| PARALLEL | The degree of parallelism to use for the session. This parameter is
used during the creation of the destination table (DEGREE parameter) and
will dictate the number of threads per instance for future scans on the
table. During the downtime steps the final DEGREE parameter value for
the table will be set to the current value of the IN_DOC table as
recorded in the SOURCE_TABLE_DEGREE column of the
IN_DB_UPGRADE_CONTROL_SYNC 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 creation of the destination table is
logged (LOGGING) or not logged (NOLOGGING). If shipping archived redo
logs for replication, then use LOGGING. Note that with the NOLOGGING option the table 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 in. The
user must have a sufficient quota on the tablespace. The default value is defined in the DEFAULT_DATA_TS_NAME column of the IN_DB_UPGRADE_CONTROL_SYNC table. The default value is the current location of the IN_DOC table. |