Windchill 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
Database must have Oracle Text, Enterprise Manager Repository and Oracle XML DB feature installed
Required Tablespaces:
USERS
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 following database properties to activate Function -based indexes support:
query_rewrite_enabled='true'
query_rewrite_integrity='enforced'
Database user must be granted followings privileges:
Connect
Resource
Create Sequence
Create View
Unlimited Tablespace
Database must have a defined Service Name that is registered with Oracle listener.
* 
Do not grant DBA or Database Admin roles or privileges to Windchill database users.
Was this helpful?