Create tablespaces for Data Validator staging/landing tables and indexes - HxGN SDx - Update 31 - Installation & Upgrade

Installation and Setup for HxGN SDx Application Server

Language
English (United States)
Product
HxGN SDx
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
10

If you are using Data Validator for loading data into your system, we recommend having dedicated tablespaces for Data Validator staging/landing tables and indexes, to avoid disk contention and fragmentation.

You can create a new tablespace using the sample script below, or interactively using an Oracle database management tool. See the Oracle documentation for information on tablespaces.

Sample script:

CREATE SMALLFILE TABLESPACE "<tablespacename>" DATAFILE '[drive]:\<tablespacename>.DBF' SIZE 5G AUTOEXTEND ON NEXT 1G MAXSIZE 8G BLOCKSIZE 8K NOLOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

When you are creating a new site in the Sever Manager using an existing user and database, or updating an existing site, you can select the tablespace for Data Validator to use during job processing. If you have not created a dedicated tablespace for Data Validator tables, the default tablespace will be used for storing the Data Validator tables and indexes.