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;
InForm LOB tablespace settings
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. |