| table fragmentation [message #383230] |
Tue, 27 January 2009 19:10  |
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 #383408 is a reply to message #383230] |
Wed, 28 January 2009 15:35  |
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 #383984 is a reply to message #383231] |
Sun, 01 February 2009 06:31 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
