DOWNTIME_STEPS - Perceptive Content Database Upgrade Package for Oracle Server - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Perceptive Content Database Upgrade Package for Oracle Server
Platform
Perceptive Content
Product
Perceptive Content Database Upgrade Package for Oracle Server
Release
Foundation 24.1
License

The DOWNTIME_STEPS procedure applies to all upgrades, but the following summary applies to upgrades with a starting schema version less than 7.5.0.0. The DOWNTIME_STEPS procedure calls all the other uptime and downtime related procedures in the order they should be executed.

This procedure executes the following procedures in the following order: IN_DB_UTIL.GET_DB_CONNECTIONS, IN_DB_UTIL.GET_DB_CONNECTIONS_COUNT, UPTIME_STEPS, SYNC_GET_STATUS, SYNC_DISABLE_TRIGGER, SYNC_TABLE_IN_DOC, CREATE_FK_IN_DOC, IN_DB_UTIL.DROP_FK, IN_DB_UTIL.DROP_INDEX, SCHEMA_UPGRADE_7133_7140, SCHEMA_UPGRADE_7140_7152, SCHEMA_UPGRADE_7152_7201, SCHEMA_UPGRADE_7220_7230, SCHEMA_UPGRADE_7230_7403, SCHEMA_UPGRADE_7403_7500, SCHEMA_UPGRADE_7500_7700, SCHEMA_UPGRADE_7700_7900, SYNC_REMOVE, IN_DB_UTIL.PRINT_SCHEMA_HIST.

Note: When DOWNTIME_STEPS is executed, the MAX_MINUTES parameter is hard coded to 0 which is equal to unlimited so that it runs to completion.

NOTICE Oracle 11.2.0.4 - Bug 28855186 : PARALLELISM NOT WORKING WHEN TRYING TO ENABLE VALIDATE CONSTRAINT on Oracle 11.2.0.4.180717 and up. This Oracle bug prevents the parallel validation of foreign key constraints for the affected versions of Oracle.