Ensuring that LOGGING is enabled
The installation for CIS references a permanent and a temporary tablespace in which to create the CIS database users. You specify the tablespace names when you run the installation.
When the tablespaces are created, the Oracle LOGGING option for LOB storage (BLOB and CLOB data types) must be enabled. LOGGING enabled is the default setting:
- When LOGGING is enabled, Oracle generates full rollback from data pages in the case of media failure.
- When the option is set to NOLOGGING, transactions could fail to commit or roll back if storage media fails.
If you have already created tablespaces with the NOLOGGING setting and have installed the CIS software:
- If you have installed the CIS software but have not performed a synchronization, or if you do not need to keep any data that you have synchronized, follow the instructions in Dropping and re-creating tablespaces with the option set to LOGGING.
- If you have synchronized data and want to retain the data in the CIS database, change the LOB storage option to LOGGING for the TRANSACTION_DATA column of the protocol_name.INF_TRANSACTIONDATA table for each protocol that has been created by CIS synchronization.
Copyright © 2002, 2016 Oracle and/or its affiliates. All rights reserved.