Hi Friends, While Dropping a table I am getting the following error. Can any please let me know why it is giving error.... SQL> drop table tab1; ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01422: exact fetch returns more than requested number of rows Regards Sambasiva Reddy.K

Hi Friends I found the reason. What happend is few days back i have inserted a value in dual table. like below SQl> insert into dual values('Y'); SQL> commit; after that i have checked the dual table like below SQL> select * from dual; DUMMY ----- X 'Y' value is not showing. Actually that 'Y' value is inserted in dual table. check the below steps SQl> create table xx_dual_copy as select * from dual; sql> select * from xx_dual_copy; DUMMY ------ X Y SQL> DROP TABLE xx_dual_copy; 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> delete from dual where dummy = 'Y'; SQL> commit; SQL> drop table xx_dual_copy; Table dropped. Regards, Sambasiva Reddy.K

DUAL is programmed to return ONE row in later releases of Oracle, and it is NOT a table to be inserting records into as you have found out by experience.