Monday, September 6, 2010

can't drop table

drop table xyz;

ORACLE SAYS : exact fetch returns more than requested number of rows ? ? ? how come . . .

yea, once i was playing with dual table and i inserted new row in a dual table which is why i can't drop this table xyz

to Add Rows in Dual table connect to sysdba

1) conn / as sysdba
2) insert into dual values('Z');


Now if you try to drop any table you will get above error to solve it just delete one row from dual table
as

delete from dual where dummy='Z'

Thats it! Now you can drop any table you want without any errors!
Thank You!

No comments:

Post a Comment