Moving extents

There are two common reasons for moving extents:

• As your database grows, you may find that your file system is running out of disk space and you need to move extents to a new location to allow for future growth. To monitor disk space usage, you can use your operating system’s file management tools.
• If you find that you need to frequently add extents to a storage area, it indicates that there is a lot of update activity on the table(s) in the area. If this area resides on the same disk as other storage areas, you may want to move extents associated with the area to a separate, faster disk to improve performance.
• Before you can move extents, you must bring your database offline.