Previous Topic

Next Topic

Book Contents

Book Index

Creating the INFORM_LOB tablespace

The INFORM_LOB tablespace is optional for InForm installation. 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.

Use of this tablespace is optional, but, if used, the name INFORM_LOB is required for this tablespace. This tablespace can be used to hold large objects.

Copyright © 2014, 2016 Oracle and/or its affiliates. All rights reserved.