Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\core\latest\purge\purge_indexes.sql
Rem drv: <create type="indexes"/> Rem Rem $Header: purge_indexes.sql 29-jun-2005.01:48:35 gsbhatia Exp $ Rem Rem purge_indexes.sql Rem Rem Copyright (c) 2003, 2005, Oracle. All rights reserved. Rem Rem NAME Rem purge_indexes.sql - <one-line expansion of the name> Rem Rem DESCRIPTION Rem <short description of component this file declares/defines> Rem Rem NOTES Rem <other useful comments, qualifications, etc.> Rem Rem MODIFIED (MM/DD/YY) Rem gsbhatia 06/26/05 - New repmgr header impl Rem gsbhatia 02/13/05 - updating repmgr header Rem gsbhatia 02/09/05 - updating repmgr header Rem gsbhatia 02/07/05 - updating repmgr header Rem scgrover 02/01/05 - compress index Rem ktlaw 01/11/05 - add repmgr header Rem rpinnama 09/08/03 - rpinnama_purge_policies Rem rpinnama 09/08/03 - Rem rpinnama 09/08/03 - Rem rpinnama 09/05/03 - Rem rpinnama 09/05/03 - Created Rem Rem Rem Indices for MGMT_PURGE_POLICY table Rem ALTER TABLE MGMT_PURGE_POLICY ADD CONSTRAINT MGMT_PURGE_POLICY_PK PRIMARY KEY (policy_name) USING INDEX STORAGE (FREELISTS 4) INITRANS 4; Rem Rem Indices for MGMT_PURGE_POLICY_GROUP table Rem ALTER TABLE MGMT_PURGE_POLICY_GROUP ADD CONSTRAINT MGMT_PURGE_POLICY_GROUP_PK PRIMARY KEY (group_name) USING INDEX STORAGE (FREELISTS 4) INITRANS 4; Rem Rem Indices for MGMT_PURGE_POLICY_TARGET_STATE table Rem ALTER TABLE MGMT_PURGE_POLICY_TARGET_STATE ADD CONSTRAINT MGMT_PURGE_POLICY_TGT_STATE_PK PRIMARY KEY (target_guid, policy_name) USING INDEX (CREATE UNIQUE INDEX MGMT_PURGE_POLICY_TGT_STATE_PK ON MGMT_PURGE_POLICY_TARGET_STATE (target_guid, policy_name) COMPRESS 1);
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de