Author: Anton Kravchenko

Practical Tips For Moving Indexes Between Tablespaces

From time to time, a simple request to reorganize space in a tablespace leads to a more complex solution. Here’s how we moved  indexes between tablespaces.       A client requested we reduce the size of an Automatic Storage…

Read More >

Needles and Pins

Sometimes clients ask us to implement scripts that change objects in their schemes. In order to prevent the situation when these scripts hung just because some, or several, objects are pinned. Here are two simple procedures that can help to check what we will get during our maintenance.

Read More >