Home » RDBMS Server » Server Administration » table fragmentation
table fragmentation [message #383230] Tue, 27 January 2009 19:10 Go to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Hi,
We have oracle 10g database. Can someone tell me when we have to do maintanence work for table fragmentation? Is there any script available that tells the fragmented tables? Is export and import is the only way to defragment the tables?
Thanks
Re: table fragmentation [message #383231 is a reply to message #383230] Tue, 27 January 2009 19:15 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.


>Can someone tell me when we have to do maintanence work for table fragmentation?
For Local Managed Tablespace, the answer is NEVER.
Re: table fragmentation [message #383408 is a reply to message #383230] Wed, 28 January 2009 15:35 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
caprikar wrote on Tue, 27 January 2009 20:10
Hi,
We have oracle 10g database. Can someone tell me when we have to do maintanence work for table fragmentation? Is there any script available that tells the fragmented tables? Is export and import is the only way to defragment the tables?
Thanks


Define what you think fragmentation is and why you think you have it.
Re: table fragmentation [message #383639 is a reply to message #383408] Thu, 29 January 2009 07:36 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
HERE you can find the blog titled TABLE FRAGMENTATION By taj one of the moderator of ORAFAQ.
http://www.orafaq.com/blog/mohammad_taj
Sriram
Re: table fragmentation [message #383984 is a reply to message #383231] Sun, 01 February 2009 06:31 Go to previous message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
BlackSwan wrote on Wed, 28 January 2009 12:15

For Local Managed Tablespace, the answer is NEVER.

...unless you selected MANUAL segment space management when creating the tablespace.

Ross Leishman
Previous Topic: ORA-00214: controlfile error
Next Topic: OPatch error
Goto Forum:
  


Current Time: Tue Dec 10 02:59:26 CST 2024