Index: openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.20-0.21.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.20-0.21.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.20-0.21.sql	26 Sep 2006 00:22:45 -0000	1.3
+++ openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.20-0.21.sql	26 Sep 2006 02:22:58 -0000	1.4
@@ -13,6 +13,15 @@
 alter table as_assessments add type varchar2(1000);
 update as_assessments set type='survey' where type_int = 1;
 update as_assessments set type='test' where type_int = 2;
+
+drop view as_assessmentsx;
+drop view as_assessmentsi;
+
+begin
+content_type.refresh_view('as_assessments');
+end;
+/
+
 alter table as_assessments drop type_int;
 update acs_attributes set datatype='string' where attribute_name='type' and object_type='as_assessments';