Charles Rajendran Charles Rajendran - 6 months ago 29
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...).

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download