Scripts and commands for Oracle

You can use database scripts and commands to manage your Oracle Database.

Use following scripts and commands for managing Oracle databases:

Scripts for Oracle

analyze_schema.sh: Updates the statistics.
drop_temp_agg_tables.pl: A bash script that drops temporary aggregate tables.
drop_log_tables_seq.pl: A bash shell script that drops all temporary tables that begin with TCTG_ULE_USER_LOG_ENTRY and its associated temporary sequences in the database to restore storage space. Starts SQLPLUS for Oracle.
Important: If you use User-Defined Logs in business logic or for auditing, do not run this script. Starting this script deletes all User-Defined Logs entries.
index_compress.sql: Periodically compressing indexes on table ita might help reduce the database size and increase performance of the rich-search function on "indexed" attributes.

Commands for Oracle

Place the following commands in the index_compress.sql file:

ALTER INDEX ICTG_ITA_0 REBUILD COMPRESS;
ALTER INDEX ICTG_ITA_1 REBUILD COMPRESS; 
ALTER INDEX ICTG_ITA_2 REBUILD COMPRESS; 
ALTER INDEX ICTG_ITA_3 REBUILD COMPRESS;

Note: You must shut down Product Master before you run these ALTER INDEX commands.

Save the index_compress.sql file in the $TOP directory and run the commands from within the $TOP directory in the following manner:

perl $PERL5LIB/runSQL.pl --sql_file=index_compress.sql

This process can take from a few minutes to several hours for completion.