File format: $BSE/lib/ora/ora_storage_param

The storage parameter file provides a way to specify the distribution of table and index data in various tablespaces. The database driver uses the storage parameters whenever you want to run a DDL statement, such as a create table or create index statement. The following is an example of an entry in the storage parameter file:

*:*:T: TABLESPACE dataspace PCTFREE 5

In this example, the database driver adds the “<tablespace>” clause to the create statement during index or table creation. If the segment for a table or index is not specified, the table and index data are created in the default tablespace. If index data is to be separated, you must specify a tablespace.

A storage parameter file is defined for each database driver. The storage file for the LN Oracle database driver is called ora_storage_param and is located in the Windows directory %BSE%\lib\ora or the UNIX directory $BSE/lib/ora.

The entries in the ora_storage_param file consist of fields that are the same for the storage files for all database drivers and storage parameters specific to the Oracle database driver.

The file must consist of zero or more entries, each consisting of several fields separated by colons. The format of an entry in the storage file is (primary key in bold):

 <Table/Module Specification> : <Company Number> : <Object Type> :[<compress specification>] <Storage Parameters>

Each of the fields in an entry in the storage parameter file are described in the section Parameter file field descriptions.

The drivers scan this file top-down. The first matching line is used, but not the best matching line.