media/image12.png

After you move the extents to their new location, you can update the .db file of the database using the PROSTRCT REPAIR utility. PROSTRCT REPAIR updates an extent’s directory information in the .db file with the information in the .st file.

The command to update the .db file of a database offline is:

prostrct repair db-name [.st-file]

If you omit the .st file, PROSTRCT REPAIR uses the db-name.st file to update the .db file.

Assume that the sports database is offline. Also assume that the sports.st file contains the most up-to-date extent information about the sports database.

To update the sports.db file offline, enter:

prostrct repair sports