Oracle cannot delete table ORA-00604ORA-01422 Error

[TEST1 @ orcl] SQLgt; droptablet10; droptablet10 * 1st rows error: ORA-00604: recursive SQL Level 1 error ORA-01422: actual return

[TEST1 @ orcl] SQLgt; drop table t10; drop table t10 * 1st row error: ORA-00604: recursive SQL Level 1 error ORA-01422: actual return

[TEST1 @ orcl] SQL> drop table t10;
Drop table t10
*
Row 3 has an error:
ORA-00604: recursive SQL Level 1 error
ORA-01422: the number of rows actually returned exceeds the number of requested rows

Check the dual table. It may be that the dual table has multiple rows of data. Delete all data and insert 'x '.

[SYS @ orcl] SQL> select * from dual;

DU
--
X

[SYS @ orcl] SQL> delete from dual;

One row has been deleted.

[SYS @ orcl] SQL> select * from dual;

DU
--
Y

[SYS @ orcl] SQL> delete from dual;

One row has been deleted.

[SYS @ orcl] SQL> select * from dual;

DU
--
M

[SYS @ orcl] SQL> delete from dual;

One row has been deleted.

[SYS @ orcl] SQL> select * from dual;

Unselected row

[SYS @ orcl] SQL> insert into dual values ('x ');

One row has been created.

[SYS @ orcl] SQL> COMMIT;

Submitted.

[SYS @ orcl] SQL> conn test1
Enter the password:
Connected.
[TEST1 @ orcl] SQL> drop table;

The table has been deleted.

The strange thing is why the dual table has two more rows of records and I didn't insert data. Study again when you are free.

,