genxrem.sql

Oracle PL/SQL procedure generator (second generator type)

/******************** PL/Generator from Quest Software *********************
||
||    File: genxrem.sql
||  Author: Steven Feuerstein
||
|| Removal script for GenX
||
|| Copyright (C) 1998-1999 Quest Software, Inc.
|| All rights reserved.
||
|| For more information, call Quest Software at 1-800-REVEAL4
|| or check out our Web page: www.Quest Software.com
||
|| Don't forget to check the plgrem.log file for errors!
||
******************************************************************/
TTITLE off

SPOOL genxrem.log

DROP TABLE plg_doir;
DROP SEQUENCE plg_doir_seq;
DROP SEQUENCE plggen_seq;
DROP SEQUENCE PLG_SOURCE_SEQ;
DROP TABLE plg_source;
DROP TABLE plg_driver_source;


DROP VIEW oir_global_wrap;
DROP VIEW oir_schema_wrap;
DROP VIEW oir_table_wrap;
DROP VIEW oir_driver;
DROP VIEW oir_global_file;
DROP VIEW oir_schema_file;
DROP VIEW oir_table_file;
DROP VIEW oir_identifier;
DROP VIEW oir_allprivs;
DROP VIEW oir_all_generations;
DROP VIEW oir_user_generations;
DROP VIEW OIR_DRIVER_SOURCE;
DROP VIEW OIR_USERPRIVS;

DROP PACKAGE plgdoir;
DROP PACKAGE plgdrv;
DROP PACKAGE plggen;
DROP PACKAGE plggenv;
DROP PACKAGE plgte;
DROP PACKAGE plgval;
DROP PACKAGE plgerr;
DROP PACKAGE plgpriv;
DROP PACKAGE plgadmin;
DROP PACKAGE plgdesc;
DROP PACKAGE plgplsql;
DROP PACKAGE plgjava;
DROP PACKAGE PLGBOOL;
DROP PACKAGE PLGCOLS;
DROP PACKAGE PLGCONS;
DROP PACKAGE PLGFKYS;
DROP PACKAGE PLGINDS;
DROP PACKAGE PLGISEG;
DROP PACKAGE PLGLST;
DROP PACKAGE PLGOBJ;
DROP PACKAGE PLGOFST;
DROP PACKAGE PLGPKY;
DROP PACKAGE PLGPRS;
DROP PACKAGE PLGSTK;
DROP PACKAGE PLGSTR;
DROP PACKAGE PLGVAR;
DROP FUNCTION PLGHASH;
DROP PACKAGE PLGIHASH;
DROP PACKAGE PLGcgml;
DROP PACKAGE PLGTYPE;
DROP PACKAGE plgsrchash;

DROP PROCEDURE plgconfirm;
DROP PROCEDURE plgconfirm_eval;
DROP PROCEDURE genxconfirm;
DROP PROCEDURE genxconfirm_eval;

DROP PUBLIC SYNONYM plg_doir;
DROP PUBLIC SYNONYM oir_global_wrap;
DROP PUBLIC SYNONYM oir_schema_wrap;
DROP PUBLIC SYNONYM oir_table_wrap;
DROP PUBLIC SYNONYM oir_driver;
DROP PUBLIC SYNONYM oir_global_tfile;
DROP PUBLIC SYNONYM oir_schema_tfile;
DROP PUBLIC SYNONYM oir_table_tfile;
DROP PUBLIC SYNONYM oir_identifier;
DROP PUBLIC SYNONYM oir_allprivs;
DROP PUBLIC SYNONYM oir_all_generations;
DROP PUBLIC SYNONYM oir_user_generations;

DROP PUBLIC SYNONYM plgdoir;
DROP PUBLIC SYNONYM plggen;
DROP PUBLIC SYNONYM plggenv;
DROP PUBLIC SYNONYM plgte;
DROP PUBLIC SYNONYM plgval;
DROP PUBLIC SYNONYM plgerr;
DROP PUBLIC SYNONYM plgpriv;
DROP PUBLIC SYNONYM plgadmin;
DROP PUBLIC SYNONYM plgplsql;
DROP PUBLIC SYNONYM plgjava;

TTITLE 'GenX Objects Still in Schema'
SELECT object_name, object_type
  FROM user_objects
 WHERE object_name LIKE 'PLG%';
TTITLE OFF

SPOOL OFF