Previous Topic

Next Topic

Book Contents

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.

Send Feedback