Rem drv:
Rem
Rem $Header: admin_data_upgrade.sql 18-jul-2005.17:39:12 chyu Exp $
Rem
Rem admin_data_upgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.
Rem
Rem NAME
Rem admin_data_upgrade.sql -
Rem
Rem DESCRIPTION
Rem
Rem
Rem NOTES
Rem
Rem
Rem MODIFIED (MM/DD/YY)
Rem chyu 07/18/05 - updating the new rep manager header
Rem jsadras 06/22/05 - register logging modules
Rem scgrover 02/01/05 - scgrover_compress_indexes_050131
Rem scgrover 01/31/05 - Created
Rem
Rem put Index compression here since we need to call a plsql procedure to do it.
BEGIN
EMD_MAINTENANCE.COMPRESS_INDEX('INDEX_SIZES_PRIMARY_KEY', 1, FALSE);
EMD_MAINTENANCE.COMPRESS_INDEX('TABLE_SIZES_PRIMARY_KEY', 1, FALSE);
END;
/
Rem register logging modules
BEGIN
mgmt_log.register_logging_module ('MAINT PIN PLSQL','EM Pin PL/SQL Blocks');
mgmt_log.register_logging_module ('ANALYZE OBJECTS WITHOUT STATS',
'Maintenance (Analysis), Objects without Statistics') ;
END ;
/