Database Administration (MOSC)

MOSC Banner

Is there a way other than add more datafile to tablespace for space ran out issue?

edited Sep 10, 2015 10:07AM in Database Administration (MOSC) 3 commentsAnswered

Hi:

Usually when space are used up in the tablespace, I always add new datafile or extend the current datafile to a larger size. Somehow one of our very senior dba has another way to tackle this issue. He usually adds more space only at the very last resort. He told me he will reconcile the current space in the tablespace first. I don't totally understand how he does reconcile and he would not tell me. But often times, it does resolve the issue without having to add more space. Do any gurus here know what method it could be? Thanks

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