Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

SQL query can be run to determine if there are any datatypes that will not be supported by Dbvisit Replicate.

...

Unsupported data types are listed here: Unsupported Datatypes

 Unsupported functionality is listed here: Functionality Currently NOT Supported.

 

Note
titleDatabase NLS Settings

The NLS_LANG variable is set at the apply environment and behaves like the NLS_LANG environment does: it sets the language, territory and character set of the apply session. The language and territory are not very important (they affect things like Oracle error messages shown), the character set must be set to the source database character set, so the any character strings applied are treated correctly according the character set they are in.
(NCHARSET) - Database national character set: 
This is the national character set of the source database. This is relevant only for NCHAR/NVARCHAR2 columns.
Only UTF8 and AL16UTF16 values are supported; Oracle expects Unicode values to be specified in UTF16, so if the source database is using UTF8 (specified by this setting), apply does the necessary conversion to UTF16.