2 Replies Latest reply: Jan 26, 2010 1:51 PM by 748991 RSS

    OWB Oracle By Example Course - Issue with OE User

    748991
      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;
      declare
      *
      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)+_
      declare

      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 ;

      begin

      for r_object in c_object(l_grantee)
      loop

      execute immediate r_object.grant_statement ;

      end loop;

      end ;
      /

      Course Web Address+_
      http://www.oracle.com/technology/obe/obe_bi/lesson1_overview/overview.htm#p