- Oracle Goldengate 11g Complete Cookbook
- Ankur Gupta
- 285字
- 2021-08-04 09:59:51
Supported datatypes in Oracle GoldenGate
Oracle GoldenGate has some restrictions in terms of what it can replicate. With every new release, Oracle is adding new datatypes to the list of what is supported. The list of the datatypes of the objects that you are planning to replicate should be checked against the list of supported datatypes for the GoldenGate version that you are planning to install.
Getting ready
You should have identified the various datatypes of the objects that you plan to replicate.
How to do it…
The following is a high-level list of the datatypes that are supported by Oracle GoldenGate v11.2.1.0.1:
NUMBERBINARY FLOATBINARY DOUBLECHARVARCHAR2LONGNCHARNVARCHAR2RAWLONG RAWDATETIMESTAMPCLOBNCLOBBLOBSECUREFILEandBASICFILEXMLdatatypesUser defined/AbstractdatatypesSDO_GEOMETRY,SDO_TOPO_GEOMETRY, andSDO_GEORASTERare supported
How it works…
There are some additional details that one needs to consider while evaluating the supported datatypes for a GoldenGate version. For example, the user-defined datatypes are only supported if the source and target tables have the same structures. Both Classic and Integrated Capture modes support XML types which are stored as XML, CLOB, and XML binary. However, XML type tables stored as Object Relational are only supported in Integrated Capture mode.
There's more…
The support restrictions apply to a few other factors apart from the datatypes. Some of these are as Manipulating Data:
INSERTs,UPDATEsandDELETEsare supported on regular tables, IOTs, clustered tables and materialized views- Tables created as
EXTERNALare not supported - Extraction from compressed tables is supported only in Integrated Capture mode
- Materialized views created with
ROWIDare not supported - Oracle GoldenGate supports replication of the sequences only in uni-directional mode
- 30天自制操作系統(tǒng)
- Linux設(shè)備驅(qū)動開發(fā)詳解：基于最新的Linux4.0內(nèi)核
- 電腦組裝與系統(tǒng)安裝
- PLC控制程序精編108例
- 鴻蒙生態(tài)：開啟萬物互聯(lián)的智慧新時代
- Persistence in PHP with the Doctrine ORM
- Extending Bootstrap
- 嵌入式Linux應(yīng)用開發(fā)菜鳥進階
- Linux系統(tǒng)安全基礎(chǔ)：二進制代碼安全性分析基礎(chǔ)與實踐
- 細說Linux基礎(chǔ)知識
- Kali Linux 2018：Windows Penetration Testing
- Linux基礎(chǔ)使用與案例
- Linux內(nèi)核分析及應(yīng)用
- Implementing Domain-Specific Languages with Xtext and Xtend（Second Edition）
- Windows 8玩全不求人