The SYNC_RESET procedure accepts the following optional parameters.
| Parameter | Description |
|---|---|
| TABLE_NAME | The source table name for which to reset the synchronization framework. |
| PARALLEL | The degree of parallelism for the session during re-population and
primary key index creation on the destination table. The default value is defined in the DEFAULT_PARALLEL column of the IN_DB_UPGRADE_CONTROL_UPGRADE table. |
| LOGGING | Used to define the default logging option for qualifying operations.
This applies to the creation of tables and indexes. Valid options are
LOGGING or NOLOGGING. If shipping archived redo logs for replication, then use LOGGING. Otherwise, consider using NOLOGGING to reduce logging during the creation of indexes to improve performance. Note that with the NOLOGGING option, these objects will not be recoverable until they are successfully backed up. The default value is defined in the DEFAULT_LOGGING column of the IN_DB_UPGRADE_CONTROL_UPGRADE table. |