Index: openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql	1 Feb 2005 17:09:24 -0000	1.5
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql	14 Feb 2005 17:23:10 -0000	1.6
@@ -582,13 +582,16 @@
 
   cursor join_cur is
     select
-      table_name, id_column, level
+      distinct lower(table_name) as table_name,
+      id_column, level
     from
       acs_object_types
     where
       object_type <> 'acs_object'
     and
       object_type <> 'content_revision'
+    and lower(table_name) <> 'acs_objects'
+    and lower(table_name) <> 'cr_revisions'
     start with
       object_type = refresh_view.content_type
     connect by