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