A table that contains INTERVAL YEAR(precision) to MONTH datatype, which is not listed as a supported datatype, fails activation with the following error message:
sp_ctrl> activate config <name>
<owner>.<tablename> contains a data type that is currently not supported.
The event log shows the following:
sp_ctrl (irvsupu16:8516)> show log reverse
10/31/06 09:25 Process exited sp_tconf (for o.hd920) [pid = 13254] - exit(1)
10/31/06 09:25 Bad config file: file - config1; "SHA53A"."TABLE1" contains a dat
a type that is currently not supported.
10/31/06 09:25 Config compilation completed: datasrc - o.hd920; file - config1
10/31/06 09:25 Error: SHA53A.TABLE1 - DURATION data type 182 is not supported ye
t [sp_tconf(osp)/13254]
10/31/06 09:25 Notice: New activation id 4 [sp_tconf/13254]
10/31/06 09:25 Notice: Oracle version 92 [sp_tconf(osp)/13254]
10/31/06 09:25 Compiling a configuration file: datasrc - o.hd920; file - config1
10/31/06 09:25 Notice: Oracle env - hd920:/u02/oracle/product/9.2.0 [sp_tconf(pd
b)/13254]
10/31/06 09:25 Process launched: sp_tconf (for o.hd920) [pid = 13254]
10/31/06 09:25 Logging user command: oracle activate config config1
A table being activated contains an unsupported data type
Shareplex does not support all datatypes for replication. The supported datatypes as well as the exclusions are listed in Chapter 3 of Admin Guide titled "Planning Shareplex Replication" section "Part1: What you can replicate with SharePlex". To get past the above errors, the table(s) containing non-supported datatype needs to be taken out of the config file and then the config activated.
All datatype that are explicitly listed as not supported would fail with the error "<owner>.<tablename> contains a data type that is currently not supported." when you try to activate a config file containing tables holding such datatype. This is due to the program code handling such exceptions. In general, anything that is not listed explicitly as supported feature should be construed as non-supported, though the activation may or may not give the message "<owner>.<tablename> contains a data type that is currently not supported" when dealing with all such datatypes.
List of supported datatype up to Shareplex 7.6.2
CHAR
DATE
NUMBER
VARCHAR
VARCHAR2
LONG and LONG RAW up to the maximum
size allowed by the operating system
ROWID
FLOAT
RAW
B-FILE
XML
