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 |