OraFAQ Forum: Server Utilities » Tablespace Defragmentation

Home » RDBMS Server » Server Utilities » Tablespace Defragmentation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tablespace Defragmentation [message #71372]

Thu, 24 October 2002 04:01

Mohini
Messages: 3
Registered: October 2002

Junior Member

How to Defragment the tablespace in oracle.Actually if i do coelasce then it will just combine all the contiginous blocks only But i want to combine all the free blocks existing in the tablespace.How is it possible.

Thanks

Mohini

Report message to a moderator

Re: Tablespace Defragmentation [message #71373 is a reply to message #71372]

Thu, 24 October 2002 05:03

B
Messages: 327
Registered: August 1999

Senior Member

rebuild tables and indexes with new initial and new extents

Report message to a moderator

Re: Tablespace Defragmentation [message #71377 is a reply to message #71372]

Thu, 24 October 2002 08:54

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

or export with compress=y and import again (special cases like lob??? use ignore=y during import)

Report message to a moderator

Re: Add to mahesh reply [message #71388 is a reply to message #71377]

Fri, 25 October 2002 02:35

B
Messages: 327
Registered: August 1999

Senior Member

Yes it works ... but be careful...
exp can set initial to some values that don't fit with ur database ... If so ... create the table with Ur own value.
U should drop all the tables that U want to defrag

Report message to a moderator

Previous Topic:	Display top 3rd Employee Salary
Next Topic:	How to do import and export?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 15:32:37 CDT 2024