Charles Rajendran Charles Rajendran - 1 month ago 11
SQL Question

Oracle - What is storage clause in altering a constraint statement

I have a SQL block to create a primary key constraint and in that SQL statement I found a clause


storage initial


I couldn't understand what it do and what is the reason for putting it, can somebody tell me what that storage initial means when it comes to creating a constraint or index in oracle.

ALTER TABLE table_name ADD CONSTRAINT constraint_name
....
....
STORAGE INITIAL

Answer Source

As explained in the Oracle documentation, if the constraint requires an index, this clause allows defining how it should physically be stored (initial extent size...).