8 Replies Latest reply: Nov 18, 2012 12:38 PM by LaserSoft RSS

    Drop table failing

    ashish pande
      Hi,

      I am new to DBA practices and recently I was performing some operations on my test schema. While dropping unwanted tables I faced following error.
      I tried to drop them by sys user but still got the same message.

      SQL> drop table b;
      drop table b
      *
      ERROR at line 1:
      ORA-00604: error occurred at recursive SQL level 1
      ORA-01422: exact fetch returns more than requested number of rows


      SQL> drop table a;
      drop table a
      *
      ERROR at line 1:
      ORA-00604: error occurred at recursive SQL level 1
      ORA-01422: exact fetch returns more than requested number of rows


      help me to get this error solved because there is huge number of unwanted tables in my database.