Live SQL

Specifying Table Storage Attributes

View All Scripts Login to Run Script

Script Name Specifying Table Storage Attributes
Description Create a table and use the STORAGE clause to allocate space for the table.
Area SQL General / SQL Query
Referenced In Database SQL Language Reference
Contributor Oracle
Created Monday October 05, 2015

Statement 1
Oracle allocates space for the table based on the STORAGE parameter values as follows: - The INITIAL value is 8M, so the size of the first extent is 8 megabytes. - The MAXSIZE value is 1G, so the maximum size of the storage element is 1 gigabyte.
Create table and allocate space using storage parameters
```
CREATE TABLE divisions  
    (div_no     NUMBER(2),  
     div_name   VARCHAR2(14),  
     location   VARCHAR2(13) )  
     STORAGE  ( INITIAL 8M MAXSIZE 1G )
```
```
Table created.
```
Statement 2
Querying the USER_TABLES for the storage parameter INITIAL. That is the size of the first extent. NOTE: It is stored as INITIAL_EXTENT. You require an Administrator credential to view the MAX_SIZE parameter.
Query the USER_TABLES for storage parameters
```
SELECT INITIAL_EXTENT FROM USER_TABLES WHERE TABLE_NAME='DIVISIONS'
```

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database