REM $Header: wfecxtd.sql 26.0 2004/06/09 08:42:46 parsharm noship $
REM /*=======================================================================+
REM | Copyright @ 2004, 2004, Oracle.  All rights reserved.
REM +=======================================================================+
REM | FILENAME
REM |   wfecxtd.sql
REM | DESCRIPTION
REM | This script drops all the ECX objects of type TYPE as sys.
REM *=======================================================================*/
SET VERIFY OFF
WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR EXIT FAILURE ROLLBACK;
WHENEVER SQLERROR CONTINUE;
connect sys/&1 as sysdba;
drop TYPE system.ECXMSG FORCE;
drop TYPE system.ECX_INENGOBJ FORCE;
drop TYPE system.ECX_OUTENGOBJ FORCE;
drop TYPE &2..ECX_NODE_OBJ_TYPE FORCE;
/
commit;
exit;