COALESCE
NOTICE: must have DBA read authority to run this script.
This script should be run from SQL*plus prompt. This can also be placed in a file and ran from the SQL*plus prompt. Substitute dataspace names with data and indexes
|
ALTER TABLESPACE data COALESCE / ALTER TABLESPACE indexes COALESCE /
|