Database Administration (MOSC)

MOSC Banner

Unable to drop a table

edited Aug 1, 2011 2:27AM in Database Administration (MOSC) 4 commentsAnswered


Gurus,

In 11gR2, RHEL 4, Im getting the following err message.

I tried to drop the individual objects and indexes belongs to ggate owner, but still getting the same error.

SYS>drop user ggate cascade;
drop user ggate cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-14452: attempt to create, alter or drop an index on temporary table already iin use

Please help me out on this!

Thanks,
Harry

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