 DROP VIEW VWSAMPLE;
 DROP VIEW VWSAMPLEASSAY;
 DROP VIEW VWSAMPLEPROPERTY;
-EXCEPTION
- WHEN OTHERS THEN NULL;
-END;
-END LOOP;
-END;
+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;
 

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 TRIGGER A2_ARRAYDESIGN_INSERT;
DROP TRIGGER A2_ASSAYPVONTOLOGY_INSERT;
DROP TRIGGER A2_ASSAYPV_INSERT;
