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

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...).