drop table error [message #355373] |
Thu, 23 October 2008 19:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shrinika
Messages: 306 Registered: April 2008
|
Senior Member |
|
|
Hello,
Here is the version i am using.
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
I get the below error when i drop the table.
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
Any help is appreciated. Thanks
|
|
|
|
|
Re: drop table error [message #355493 is a reply to message #355379] |
Fri, 24 October 2008 08:20 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shrinika
Messages: 306 Registered: April 2008
|
Senior Member |
|
|
Ebrain,
Here is the output.
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
Michel, I just created fresh data base in my laptop. I am using windows vista Operating system. There is no DDL triggers at all..
|
|
|
Re: drop table error [message #355498 is a reply to message #355493] |
Fri, 24 October 2008 08:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Delete all rows but the first one from your dual table.
And it is wrong you just created the database without doing anything in it otherwise you will not have this stuff in dual.
Regards
Michel
[Updated on: Fri, 24 October 2008 08:42] Report message to a moderator
|
|
|
|
|
|