Create Application Tablespaces

1.2.5 Create Application Tablespaces

The Oracle Financial Services Lending and Leasing table and index creation DDL allow for the use of up to 22 different tablespaces --11 for tables and 11 for indexes.

The DDL commands reference a set of files that contain storage parameter information. These files allow mapping of logical tablespace names to physical tablespaces. Create as many of these tablespaces as necessary depending on the storage resources. Use locally managed tablespaces with a uniform extent policy.The following table describes different tablespaces, their content, and their expected growth pattern.

Table 1-5 Application Tablespaces

Tablespace	Storage Parameter File	Default Tablespace Name	Data	Comment
Admin	storage_parms_table_adm.sql storage_parms_index_adm.sql	OFSLL_ADM_DATA OFSLL_ADM_INDEX	setup data	low growth, low change.
Origination	storage_parms_table_org.sql storage_parms_index_org.sql	OFSLL _ORG_DATA OFSLL _ORG_INDEX	loan application data	growth varies by customer, few updates.
Servicing	storage_parms_table_svc.sql storage_parms_index_svc.sql	OFSLL _SVC_DATA OFSLL _SVC_INDEX	non transaction account data	growth varies by customer, few updates.
Transactions	storage_parms_table_txn.sql storage_parms_index_txn.sql	OFSLL _TXN_DATA OFSLL _TXN_INDEX	transaction data	high growth (relative to account and application data table spaces)
API	storage_parms_table_api.sql storage_parms_index_api.sql	OFSLL _API_DATA OFSLL _API_INDEX	application/account data used during imports/conversions	high growth, one time usage, data can be removed after loading
Archive	storage_parms_table_arc.sql storage_parms_index_arc.sql	OFSLL _ARC_DATA OFSLL _ARC_INDEX	Archived application/account data	steady growth, potentially very large
Common	storage_parms_table_cmn.sql storage_parms_index_cmn.sql	OFSLL _CMN_DATA OFSLL_CMN_INDEX	common non-admin data	generally low growth, some tables can be periodically truncated
Input Process	storage_parms_table_ipf.sql storage_parms_index_ipf.sql	OFSLL_IPF_DATA OFSLL_IPF_INDEX	Input processing file	steady growth, potentially very large
Output Process	storage_parms_table_opf.sql storage_parms_index_opf.sql	OFSLL_OPF_DATA OFSLL_OPF_INDEX	Output processing file	steady growth, potentially very large
Logging	storage_parms_table_log.sql storage_parms_index_log.sql	OFSLL_LOG_DATA OFSLL_LOG_INDEX	Error Logging	steady growth
Audit	storage_parms_table_aud.sql storage_parms_index_aud.sql	OFSLL_AUD_DATA OFSLL_AUD_INDEX	Audit Logging	Growth depends on enabling number of audits fields.

Figure 1-5 Command prompt window 4

Description of "Figure 1-5 Command prompt window 4"

Figure 1-6 Command prompt window 5

Description of "Figure 1-6 Command prompt window 5"

When prompted to Select a number to redefine the tablespace name, you have 2 options:

Accept default Tablespace Name and Size: Select # 21

Figure 1-7 Command prompt window 6

Description of "Figure 1-7 Command prompt window 6"

Modify the default Tablespace Name and Size: Select the number of the tablespace, between 1–20, you need to modify.

Figure 1-8 Command prompt window 7

Description of "Figure 1-8 Command prompt window 7"

Table 1-6 Script Prompts

Script Prompts	Description and Action Required
Enter new tablespace name	Enter tablespace name you need to assign to the default tablespace you have selected.
Enter tablespace size (in MB)	Enter the size (in MB) you need to assign to the new tablespace name you have entered

Repeat this process for all the tablespace names you need to modify.

Figure 1-9 Command prompt window 8

Description of "Figure 1-9 Command prompt window 8"

Enter # 21 to redefine and to apply changes for the tablespaces you modified.

Figure 1-10 Command prompt window 9

Description of "Figure 1-10 Command prompt window 9"

Table 1-7 Script Prompts

Script Prompts	Description and Action Required
Oracle tablespace path	Installed Database path that stores DBF files. Once entered the script prompts for confirmation. Enter y, if it is ok
Oracle User ID that will own the Oracle Financial Services Lending and Leasing objects	Valid User ID
Password for this User ID	Valid Password
Oracle sysdba User ID	Valid User ID
Password for sysdba User ID	Valid Password

Parent topic: Install the Application Database