Run the SQL in the Ad Hoc command window to the right.

Create the base table with INLINE LENGTH option

The INLINELOBDATA table has the same columns as the LOBDATA table except that the VIEW_TEXT column has an inline length of 500 bytes and the COLUMN_TEXT column has an inline length of 500 bytes.

The INLINE LENGTH option indicates that the maximum byte size of the LOB data to store in the base table row. If any LOB data larger than the maximum length allowed, it will be stored separately from the base table in the same way as a regular LOB column.

Again, the NOT LOGGED INITIALLY clause is used here to reduce logging activities performed on the LOBDATA table. Logging is not engaged for any operations or changes made on the table in the same unit of work that NOT LOGGED INITIALLY is used.

Populate the table with data

It inserts 10,000 rows of data into the INLINELOBDATA table.