-DECLARE
-I INTEGER;
-BEGIN
-I := 0;
-WHILE I<10 LOOP
-I := I + 1;
-BEGIN
 DROP FUNCTION LIST_TO_TABLE;
 DROP INDEX A2_CONFIG_PROPERTIES_PK;
 DROP INDEX A2_TASKMAN_LOG_IDX1;

DROP SEQUENCE A2_TASKMAN_LOG_SEQ;
DROP SEQUENCE A2_TASKMAN_TASKID_SEQ;
DROP SEQUENCE LOAD_MONITOR_SEQ;
DROP TABLE A2_ARRAYDESIGN;
DROP TABLE A2_ASSAY;
DROP TABLE A2_ASSAYPV;
DROP TABLE A2_ASSAYPVONTOLOGY;
DROP TABLE A2_ASSAYSAMPLE;
DROP TABLE A2_CONFIG_PROPERTY;
DROP TABLE A2_DESIGNELEMENT;
DROP TABLE A2_EXPERIMENT;
DROP TABLE A2_EXPRESSIONANALYTICS;
DROP TABLE A2_EXPRESSIONVALUE;
DROP TABLE A2_GENE;
DROP TABLE A2_GENEGPV;
DROP TABLE A2_GENEPROPERTY;
DROP TABLE A2_GENEPROPERTYVALUE;
DROP TABLE A2_ONTOLOGY;
DROP TABLE A2_ONTOLOGYTERM;
DROP TABLE A2_ORGANISM;
DROP TABLE A2_PROPERTY;
DROP TABLE A2_PROPERTYVALUE;
DROP TABLE A2_SAMPLE;
DROP TABLE A2_SAMPLEPV;
DROP TABLE A2_SAMPLEPVONTOLOGY;
DROP TABLE A2_TASKMAN_LOG;
DROP TABLE A2_TASKMAN_STATUS;
DROP TABLE A2_TASKMAN_TAG;
DROP TABLE A2_TASKMAN_TAGTASKS;
DROP TABLE LOAD_MONITOR;
DROP TABLE TMP_DESIGNELEMENTMAP;
DROP TRIGGER A2_ARRAYDESIGN_INSERT;
DROP TRIGGER A2_ASSAYPVONTOLOGY_INSERT;
DROP TRIGGER A2_ASSAYPV_INSERT;

DROP VIEW VWSAMPLE;
DROP VIEW VWSAMPLEASSAY;
DROP VIEW VWSAMPLEPROPERTY;
DROP TABLE A2_ARRAYDESIGN;
DROP TABLE A2_ASSAY;
DROP TABLE A2_ASSAYPV;
DROP TABLE A2_ASSAYPVONTOLOGY;
DROP TABLE A2_ASSAYSAMPLE;
DROP TABLE A2_CONFIG_PROPERTY;
DROP TABLE A2_DESIGNELEMENT;
DROP TABLE A2_EXPERIMENT;
DROP TABLE A2_EXPRESSIONANALYTICS;
DROP TABLE A2_EXPRESSIONVALUE;
DROP TABLE A2_GENE;
DROP TABLE A2_GENEGPV;
DROP TABLE A2_GENEPROPERTY;
DROP TABLE A2_GENEPROPERTYVALUE;
DROP TABLE A2_ONTOLOGY;
DROP TABLE A2_ONTOLOGYTERM;
DROP TABLE A2_ORGANISM;
DROP TABLE A2_PROPERTY;
DROP TABLE A2_PROPERTYVALUE;
DROP TABLE A2_SAMPLE;
DROP TABLE A2_SAMPLEPV;
DROP TABLE A2_SAMPLEPVONTOLOGY;
DROP TABLE A2_TASKMAN_LOG;
DROP TABLE A2_TASKMAN_STATUS;
DROP TABLE A2_TASKMAN_TAG;
DROP TABLE A2_TASKMAN_TAGTASKS;
DROP TABLE LOAD_MONITOR;
DROP TABLE TMP_DESIGNELEMENTMAP;

PURGE RECYCLEBIN;

