Creating the INFORM_LOB tablespace

To create the INFORM_LOB tablespace, use the following syntax:

CREATE TABLESPACE INFORM_LOB
DATAFILE ‘<path_to_data_file>’ SIZE <initial_size>
AUTOEXTEND ON NEXT <file_increment>
EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

Tablespace name	Initial size/ autoextend size needed	File extent size/file maximum size	Comments
INFORM_LOB	200M	Make the initial size 200 megabytes, set AUTOEXTEND on and set MAXSIZE to UNLIMITED.	This tablespace is used to hold large objects.