These pages cover Data Compare for Oracle 2, which is not the latest version. Help for other versions is also available.
Which datatypes can be compared?
Published 04 February 2013
Data Compare for Oracle supports comparison and deployment of the following datatypes:
- CHAR
- VARCHAR2
- NCHAR
- NVARCHAR2
- NUMBER
- FLOAT
- BINARY_FLOAT
- BINARY_DOUBLE
- RAW
- LONG RAW
- DATE
- TIMESTAMP
- TIMESTAMP WITH TIME ZONE
- TIMESTAMP WITH LOCAL TIME ZONE
- INTERVAL YEAR TO MONTH
- INTERVAL DAY TO SECOND
- BLOB
- CLOB
- NCLOB
- ROWID
- UROWID
- XMLTYPE
Datatypes not in this list don't appear in comparison results, and can't be deployed.
