Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\core\10.2.0.4\ecm\ecm_indexes.sql
Rem drv: <migrate type="schema_upgrade" version="10.2.0.4"/> Rem Rem $Header: ecm_indexes.sql 02-jan-2008.16:44:58 rrawat Exp $ Rem Rem patch_tables_alter.sql Rem Rem Copyright (c) 2006, Oracle. All rights reserved. Rem Rem NAME Rem ecm_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 rrawat 01/04/07 - Created Rem DECLARE l_index_name VARCHAR2(30); BEGIN BEGIN select object_name into l_index_name from all_objects where object_name='MGMT_DELTA_SNAP_IDX3' and object_type='INDEX' and owner=upper('&&EM_REPOS_USER'); EXCEPTION WHEN NO_DATA_FOUND THEN EXECUTE IMMEDIATE 'CREATE INDEX MGMT_DELTA_SNAP_IDX3 ON MGMT_DELTA_SNAP( TARGET_TYPE, SNAPSHOT_TYPE, DELTA_TYPE, DELTA_GUID )' ; END; END; /
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de