1. Installation and Configuration Guide
  2. Preparing Your Environment
  3. Preparing a Database
  4. Using an Oracle Database
  5. Oracle Database Creation Considerations

Oracle Database Creation Considerations

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.