| Fragmentation of Tablespace [message #57095] |
Tue, 20 May 2003 08:10  |
Yazmin
Messages: 13
Registered: August 2002
|
Junior Member |
|
|
Hi, I donīt speak English very well.
Mi question is the follow: How Can I do for to desfragment a Tablespace??
Please, help me
Thanks
|
|
|
|
| Re: Fragmentation of Tablespace [message #57107 is a reply to message #57095] |
Tue, 20 May 2003 22:38  |
Deepa
Messages: 269
Registered: November 2000
|
Senior Member |
|
|
On way is
To do a complete export of the Schema ,, drop the tablespace and import into a new tablespace.
Other way is the move option
SELECT 'alter TABLE '|| OWNER ||'.' ||SEGMENT_NAME || ' MOVE
tablespace GENERAL storage (initial 16M NEXT 16M PCTINCREASE 0 ) ;'
from dba_segments where TABLESPACE_NAME='GENERAL' AND segment_type='TABLE' AND BYTES <(1024*1024*10)
However, this requires double the disk space until the moves complete. This will also require you to change your tablespace name because you would have to move them to a new tablespace.
Use Locally managed Tablespaces to avoid fragmentation...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
