Database Administration (MOSC)

MOSC Banner

ORA-01422: exact fetch returns more than requested number of rows when i trying to drop,how i can fi

edited Apr 4, 2014 1:08AM in Database Administration (MOSC) 10 comments

SQL> drop table sys.t;

drop table sys.t

               *

ERROR at line 1:

ORA-01422: exact fetch returns more than requested number of rows

i have try

SQL> truncate table t;

Table truncated.

SQL> drop table t;

drop table t

           *

ERROR at line 1:

ORA-01422: exact fetch returns more than requested number of rows

what i can do now?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center