title: Oracle 11g: ORA-00604: error occurred at recursive SQL level 1
body: <p>I executed the script below and it works:</p>
  
  <pre><code>BEGIN
     FOR cur_rec IN (SELECT object_name, object_type
                   FROM user_objects
                  WHERE object_type IN
                           ('TABLE',
                            'VIEW',
                            'PACKAGE',
                            'PROCEDURE',
                            'FUNCTION',
                            'SEQUENCE'
                           ))
   LOOP
    BEGIN
       IF cur_rec.object_type = 'TABLE'
       THEN
          EXECUTE IMMEDIATE    'DROP '
                            || cur_rec.object_type
                            || ' "'
                            || cur_rec.object_name
                            || '" CASCADE CONSTRAINTS';
       ELSE
          EXECUTE IMMEDIATE    'DROP '
                            || cur_rec.object_type
                            || ' "'
                            || cur_rec.object_name
                            || '"';
       END IF;
    EXCEPTION
       WHEN OTHERS
       THEN
          DBMS_OUTPUT.put_line (   'FAILED: DROP '
                                || cur_rec.object_type
                                || ' "'
                                || cur_rec.object_name
                                || '"'
                               );
    END;
     END LOOP;
  END;
  /
  </code></pre>
  
  <p>But the problem is, after this, I cant grant, create or drop etc. in my database even I'm using a sysdba user.</p>
  
  <p>I am getting the error:</p>
  
  <blockquote>
    <p>ORA-00604: error occurred at recursive SQL level 1
    ORA-00942: table or view does not exist</p>
  </blockquote>
  
  <p>Please help. Thanks.</p>