Home » RDBMS Server » Server Administration » drop table error (oracle10g)
drop table error [message #355373] Thu, 23 October 2008 19:16 Go to next message
shrinika
Messages: 266
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 #355379 is a reply to message #355373] Thu, 23 October 2008 19:33 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Curious...what is the output of:

create table temp_dual as select * from dual;
select * from temp_dual; 
Re: drop table error [message #355405 is a reply to message #355373] Thu, 23 October 2008 23:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for a DDL trigger and have a look at its code.

Regards
Michel
Re: drop table error [message #355493 is a reply to message #355379] Fri, 24 October 2008 08:20 Go to previous messageGo to next message
shrinika
Messages: 266
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 messageGo to next message
Michel Cadot
Messages: 64124
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

Re: drop table error [message #356645 is a reply to message #355498] Fri, 31 October 2008 13:12 Go to previous messageGo to next message
shrinika
Messages: 266
Registered: April 2008
Senior Member
Michel, I am not sure what you are saying...
Can you please explain me why i am not able to drop any table in my database...

Thanks
Re: drop table error [message #356652 is a reply to message #356645] Fri, 31 October 2008 13:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because you have more than one row in your dual table.

Regards
Michel
Re: drop table error [message #356659 is a reply to message #356652] Fri, 31 October 2008 15:41 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Hello Shrinika,

As per Mr.Michel. Please check your alert log & trace file (udump).

Let us know the details.

Babu

Previous Topic: ORA-01482: unsupported character set in 10g with gather stats
Next Topic: DBMS_JOB failure
Goto Forum:
  


Current Time: Wed Dec 07 06:41:25 CST 2016

Total time taken to generate the page: 0.13849 seconds