Use the Structure Remove Online (PROSTRCT REMOVEONLINE) utility on a running database to remove extents from data storage areas, including the encryption and CDC areas. After all the extents are removed from a storage area, PROSTRCT REMOVEONLINE removes the storage area.

Note: The data storage area must contain no objects.

To remove storage area from a running database:

  1. Move objects out of the area. For example, to move tables: 
    proutil db-name -C tablemove table-name area-name

    For more information about truncating areas, see PROUTIL TABLEMOVE qualifier.

  2. To remove extents from the storage areas, use PROSTRCT REMOVEONLINE, for example: 
    prostrct removeonline db-nameextent-token [area-name][-allExtents] [-silent]
    Note: If the area name contains a space, place the storage area ame inside double quotation marks. For example: "test data."

    The -silent parameter suppresses prompts with instructions when after-imaging is enabled.

    You can remove one extent at a time, or remove all extents with -allExtents. After you have removed all of the extents from a storage area, PROSTRCT REMOVEONLINE removes the storage area and outputs descriptive information such as:

    solaris:100a$ prostrct remove service d chris
/user/joe/service_9.d3 successfully removed
solaris:100a$ prostrct remove service d chris
/user/joe/service_9.d2 successfully removed
solaris:100a$ prostrct remove service d chris
/user/joe/service_9.d1 successfully removed
  3. After removing any areas. run PROSTRCT LIST to overwrite your existing .st file and reflect the changes made to the structure of your database.