Database Administration (MOSC)

MOSC Banner

Small file tablespace

edited Jul 8, 2009 12:25AM in Database Administration (MOSC) 3 commentsAnswered ✓
 Hi, I have small file tablespace in Oracle10g r2 server. In this database have executed a lot of DML operations. For example: I frequently executed insert ,update ,delete operations.. And I droped  one user from database contained big tables which size was equal half of database. I think this tablespace must be defragment. How can i do it?. I know that "alter tablespace coalesce". But I am not sure that this is correct , and how is it work i do not know. What should do I?

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