Servigistics InService Deployment > Preparing Your Environment to Deploy Servigistics InService > Servigistics InService Requirements for the Oracle Database
  
Servigistics InService Requirements for the Oracle Database
• Database block size: 8K, 16K.
• Database NLS_CHARACTERSET: AL32UTF8 and NLS_NCHAR_CHARACTERSET: UTF8.
• NLS_LENGTH_SEMANTICS: Set to BYTE
• Required Tablespaces:
◦ USERS or Database Default Tablespace
◦ BLOBS
◦ INDX
◦ WCAUDIT
The following is a sample script to create a tablespace:
CREATE TABLESPACE “<Tablespace_Name>”
LOGGING
DATAFILE '<absolute path to the datafile name>' SIZE
1000M
AUTOEXTEND
ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 128K SEGMENT SPACE MANAGEMENT AUTO;
• Function-based indexes support enabled
Enable the following Oracle database properties to activate Function -based indexes support:
◦ query_rewrite_enabled='true'
◦ query_rewrite_integrity='enforced'
• The database schema user must be granted followings privileges
◦ Connect
◦ Resource
◦ Create Sequence
◦ Create View
◦ Query Rewrite
◦ Select any dictionary
◦ Unlimited Tablespace
* 
Do not grant DBA or Database Admin roles or privileges to Servigistics InService database users.