Previous Topic: OracleNext Topic: NEXT and PCTINCREASE Reduction


Routine Database Cleanup

Run the Cleanup utility often to delete obsolete objects and associations. For information to determine whether cleanup is necessary, see Performing CSE Cleanup.

To determine whether cleanup is necessary, set ORACLE_SID to the appropriate value for the encyclopedia database name and use sqlplus to execute the query. Typical value for ORACLE_SID is DBCSE (for older Windows encyclopedias, older UNIX encyclopedias or for newer encyclopedias on either platform).

More information:

Performing CSE Cleanup