The CREATE_PK_IN_DOC procedure creates the primary key constraint and primary key index and the primary key case insensitive (PKCI) NLS function-based index on the new IN_DOC table (NEW_DOC). This procedure is indirectly executed by the UPTIME_STEPS procedure or can be executed manually after running CREATE_DEST_TABLE_IN_DOC, and LOAD_DEST_TABLE_IN_DOC.
Note:
- The indexes created by this procedure must be in place prior to starting the synchronization process or the performance of the sync process will be severely impacted.
- This procedure will create both the primary key index (PK_NEW_DOC) and the case insensitive unique index (PKCI_NEW_DOC) and does not honor the MAX_MINUTES parameter.