Friday , July 19 2024

SET UNUSED In Oracle

In today’s article, we will talk about how to use the SET UNUSED command in cases where dropping the column will take time.

We use SET UNUSED in cases where dropping the column will take time.

The columns used with this expression are not actually deleted but are marked as unused.

Columns marked as unused do not appear in both queries and data dictionary views.

Its name has been deleted, a new column with the same name can be created.

Indexes, constraints and statistics of columns marked as Unused are deleted.

Unused columns are dropped as follows.

It is used to perform the checkpoint operation when the specified number of rows is undoed in order to prevent unnecessary undo formation by performing the checkpoint operation at certain intervals.

Loading

About Onur ARDAHANLI

Leave a Reply

Your email address will not be published. Required fields are marked *

Categories