2 Replies Latest reply on Jan 26, 2010 7:51 PM by user8250410

    OWB Oracle By Example Course - Issue with OE User

      I have been attempting to perform the OBE course for OWB but the when attempt to perform the Oracle provided sql script with user OE , the script fails with the following error, can anyone help me with this issue:

      Error Message Below+_
      SQL> @c:\create_grants;
      ERROR at line 1:
      ORA-25191: cannot reference overflow table of an index-organized table
      ORA-06512: at line 17

      Oracle Provided Sql File (create_grants.sql)+_

      l_grantee varchar2(30) := 'PUBLIC' ;

      cursor c_object (p_grantee varchar2) is
      select 'grant select on ' || table_name || ' to ' || p_grantee grant_statement
      from user_tables
      union all
      select 'grant select on ' || view_name || ' to ' || p_grantee
      from user_views ;


      for r_object in c_object(l_grantee)

      execute immediate r_object.grant_statement ;

      end loop;

      end ;

      Course Web Address+_