REM $Header: afsvcidd.sql 26.1 2004/06/02 16:35:06 viksingh noship $
REM ***********************************************************************
REM   NAME
REM       afsvcidd.sql - GSC InDeX Drop
REM   DESCRIPTION
REM       Drops indexes on all GSC tables
REM   USAGE
REM       sqlplus apps/apps @afsvcidd applsys fnd
REM ********************************************************************
REM Connect to base account
REM (autopatch will run all scripts in apps account)

REM   dbdrv: none

connect &1/&2;

REM Continue in case of error where index does not exist
WHENEVER SQLERROR CONTINUE;

/*
** Start dropping all indexes. 
** some of these indexes (or their bas table) may not exist 
** - do not be concerned 
*/

-- Only indexes explicitly created are dropped, not the ones that are created 
-- automatically for PKs

DROP INDEX FND_SVC_COMPONENTS_U2;
DROP INDEX FND_SVC_COMP_REQUESTS_N1;
DROP INDEX FND_SVC_COMP_PARAM_VALS_U2;
DROP INDEX FND_SVC_COMP_PARAM_VALS_N1;
DROP INDEX FND_SVC_COMP_REQUESTS_H_N1;
DROP INDEX FND_SVC_COMP_PARAMS_B_N1;

commit;
exit;