Oracle Database Creation Considerations

This section describes database creation requirements for optimized repository performance, appropriate tablespace sizing, and RCU schema setup.

The database must be created using Unicode Transformation Format UTF-8 encoding (character set). Oracle supports the following character sets with UTF-8 encoding:

• AL32UTF8 (UTF-8 encoding for ASCII platforms)

• UTF8 (backward-compatible encoding for Oracle)

• UTFE (UTF-8 encoding for EBCDIC platforms)

Oracle recommends that you add a prefix to the user name that will correspond to the RCU schema prefix used during configuration.

Note:

For Oracle Data Relationship Management, the database needs to use these database parameters:

• NLS_NCHAR_CHARACTERSET AL16UTF16
• NLS_CHARACTERSET AL32UTF8

For optimal performance, when cloning schemas in a Data Relationship Management environment, Oracle recommends the use of datapump over copying schemas using the Data Relationship Management Console repository wizard.