Database Administration (MOSC)

MOSC Banner

Getting ORA-01652 when gathering stats

edited Dec 2, 2009 6:23PM in Database Administration (MOSC) 4 commentsAnswered ✓
Hi!

We are facing a ORA-01652 when gathering stats on our 10.2.0.4#25 database. It only happens in one database and the table is not that big (6.4million rows). I have tried to double the size of the datafile in the TEMP tbs but I still get the error.

Any clues?

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