Move the databases.xml in the conf folder. (.../Perspectium_Replicator_Agent_Oracle/conf). Then, in the databases.xml, you will need to change the following values: Old Value | New Value |
---|
NCLOB | NVARCHAR2(2000) | BINARY_DOUBLE | NUMBER(15\,2) |
Snippet of databases.xml: Code Block |
---|
<database>
<database_type>oracle</database_type>
<datatypes>
<mapping sn_type="4" db_type="-5">NUMBER(38)</mapping>
<mapping sn_type="6" db_type="6">NUMBER(15\,2)</mapping>
<mapping sn_type="16" db_type="-15">NCHAR(1)</mapping>
<mapping sn_type="91" db_type="91">DATE</mapping>
<mapping sn_type="93" db_type="93">TIMESTAMP</mapping>
<mapping sn_type="12" db_type="-9">NVARCHAR2</mapping>
<mapping sn_type="2011" db_type="2011">NVARCHAR2(2000)</mapping>
</datatypes>
<can_alter_length/>
<column_max_size>2000</column_max_size>
<column_max_type>NVARCHAR2(2000)</column_max_type>
<column_max_sql_type>2011</column_max_sql_type>
.
.
. |
|