1 2 Previous Next 20 Replies Latest reply: Mar 12, 2013 12:31 PM by Wile E Coyote RSS

    not able to drop a table in 10g for strange reason... help please..

    knowledgespring
      SQL> select * from t1;

      no rows selected

      SQL> desc t1;
      Name Null? Type
      ----------------------------------------- -------- ----------------------------
      T1 NUMBER

      SQL> drop table t1;
      drop table t1
      *
      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> select * From v$version;

      BANNER
      ----------------------------------------------------------------
      Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
      PL/SQL Release 10.2.0.1.0 - Production
      CORE 10.2.0.1.0 Production
      TNS for Linux: Version 10.2.0.1.0 - Production
      NLSRTL Version 10.2.0.1.0 - Production


      it is started coming after i created foreign key in a table using

      ALTER TABLE xxx ADD CONSTRAINT xxx FOREIGN KEY (xxx) REFERENCES xxx (xxx) DEFERRABLE;

      was anything went wrong?.. what to do now?. ..



      i am not able to drop any table in schema or in entire database.. please help out? thanks a lot in advance.
        1 2 Previous Next