Oracle7 Server Utilities

Reducing Database Fragmentation

A database with many non-contiguous, small blocks of free space is said to be fragmented. A fragmented database should be reorganized to make space available in contiguous, larger blocks. You can reduce fragmentation by performing a full database export/import as follows:

1. Do a full database export (FULL=Y) to back up the entire database.

2. USE the MONITOR command in SQL*DBA or Server Manager to check for active database users. Do not shut down Oracle until all users are logged off.

3. Recreate the database using the CREATE DATABASE command.

4. Do a full database import (FULL=Y) to restore the entire database. See the Oracle7 Server Administrator's Guide for more information about creating databases.