Table Reorganization

How to Move Tables by SQL Script

by Ed Chen
January 16, 2017March 28, 2018

I usually move some tables for data reorganization, and I found the procedure is pretty routine:Moving the table.Rebuilding indexes related to this table.Analyzing all segments… Read More »

What is Difference Between PCT_FREE and PCT_USED

by Ed Chen
April 12, 2014January 23, 2021

For manual segment space management (MSSM), we have to define the two parameters in a table in order to meet our target space plan. Let… Read More »