Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

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

create table temp_dual as select * from dual;
select * from temp_dual; 

SQL> create table temp_dual as select * from dual;

Table created.

SQL> select * from temp_dual;

D
-
X
X
X
X
1
1
1

7 rows selected.

SQL> select * from dual;

D
-
X