To shrink or to move

If you delete most of the rows in one table, you probably want to regain that space, to minimize IO and fragmentation. If you delete most of the rows in most of the tables, you probably also want to resize the datafile to reduce storage and backup space. In this case, you could move your… Continue reading To shrink or to move

Published
Categorized as 12cR2, dba Tagged