| CREATE TABLE <table_name> |
The CREATE TABLE statement specifying the table name |
| <column_name> <lob_type>, | The column name with the LOB data type |
| <column_name> <data_type>, …) | The column name with other data type |
| LOB (lob_column_name) store as | LOB parameters stipulating the way a LOB column is stored within the database |
| (TABLESPACE <tablespace_name> | The tablespace name for storing the LOB column |
| CHUNK <value> | The CHUNK value for manipulation of the LOB |
| PCTVERSION <value> | The PCTVERSION for versioning of the LOB |
| CACHE / NOCACHE | For logging of the transactions within the redo log buffer |
| STORAGE <parameters>)); | The storage parameters |
| CREATE TABLE CUSTOMER_PHOTO_OBJ_TABLE | The CREATE TABLE statement specifying the table name |
| CUSTOMER_ID NUMBER (10), | The column name with the NUMBER data type |
| CUSTOMER_PHOTO BLOB, | The column name with the LOB data type |
| CREATED_DATE DATE) | The column name with the DATE data type |
| LOB (CUSTOMER_PHOTO) STORE AS | LOB parameters stipulating the way a LOB column is stored within the database |
| (CHUNK 4096 | The CHUNK value for manipulation of the LOB |
| PCTVERSION 5 | The PCTVERSION for versioning of the LOB |
| NOCACHE LOGGING | For logging of the transactions within the redo log buffer |
| STORAGE (MAXEXTENTS 5)); | The storage parameters |
