Can GoldenGate Replicate An Oracle Table That Contains Only CLOB Column(s)? (Doc ID 971833.1)
Oracle GoldenGate - Version 4.0.0 and later
Information in this document applies to any platform.
SOLUTION
Question
Can GoldenGate replicate an Oracle table that contains only CLOB columns?
Answer
To ensure Data Integrity when performing Update and Delete operations, GoldenGate requires each Source and Target Table to have a Unique Identifier. This Unique Identifier can be:
* a Primary Key
* a Unique Index
* one or more columns that contain unique values and are specified with a GoldenGate KEYCOLS clause.
To make those columns available to GoldenGate, they must be logged to the Redo Log by Oracle's Supplemental Logging feature. Oracle does not support Supplemental Logging for CLOB columns; therefore Updates and Deletes on those columns cannot be replicated by GoldenGate.
If you attempt to enable Supplemental Logging for a CLOB column, either with the GoldenGate ADD TRANDATA command or through SQL*Plus, you will receive the following errors:
SQL> create table ggs.customers (a clob, b clob);
GGSCI (xxx) 4> add trandata customers
No key found for table GGS.CUSTOMERS. All columns will be logged.
2007-05-24 10:37:57 GGS WARNING 301 WARNING: key column may exists after column A, may not be able
to handle row chaining.
2007-05-24 10:37:57 GGS WARNING 301 WARNING: key column may exists after column B, may not be able
to handle row chaining.
2007-05-24 10:37:57 GGS WARNING 301 Table GGS.CUSTOMERS has no valid key columns, no supplemental log group was added.
SQL> alter table customers add supplemental log group customers_s (a) always;
alter table customers add supplemental log group customers_s (a) always
*
ERROR at line 1:
ORA-30569: data type of given column is not supported in a log group
Error: ORA-30569 (ORA-30569)
Text: data type of given column is not supported in a log group
Cause
An attempt was made to include a column with one of these Unsupported Data Types: LONG, VARRAY, nested table, object, LOB, FILE, or REF in a Log Group.
Action
Change the Column Data Type or remove the Log Group. Then retry the operation.
其它:
相關文章
- How To Replicate Data from Oracle to Postgres Using GoldenGate (Doc ID 1544137.1OracleGo
- Master Note - Oracle GoldenGate (Doc ID 1298817.1)ASTOracleGo
- Goldengate Replicate Mode介紹Go
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- Android @Field parameters can only be used with form encodingAndroidORMEncoding
- Can Tapes Be Used For RMAN Convert Database (Doc ID 563816.1)Database
- Android8.0適配-Only fullscreen opaque activities can request orientationAndroidOpaque
- replicate-rewrite-db和Replicate_Wild_Do_Table實現表級別對映覆制
- for public synonym, only sys user can compile it?Compile
- Oracle GoldenGate 11g官方文件Administrator’s GuideOracleGoGUIIDE
- v$lock之alter table drop column與alter table set unused column區別系列五
- SQLAlchemy Table(表)類方式 – Table類和Column類SQL
- 解決Android 8 0的Only fullscreen opaque activities can request orientatioAndroidOpaque
- Script: To remove Chained Rows from a Table (Doc ID 1019556.6)REMAI
- oracle GoldenGate Veridata配置OracleGo
- 轉:Oracle GoldenGate VeridataOracleGo
- 【React】Invalid hook call. Hooks can only be called inside of the body of a function component.ReactHookIDEFunction
- MySQl報錯之@@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ONMySql
- oracle10g Online Table Redefinition testing and related docOracle
- [doc]How To Efficiently Drop A Table With Many Extents
- Oracle GoldenGate 11g官方文件Administrator’s Guide續四OracleGoGUIIDE
- Oracle GoldenGate 11g官方文件Administrator’s Guide續三OracleGoGUIIDE
- Oracle GoldenGate 11g官方文件Administrator’s Guide續二OracleGoGUIIDE
- Oracle GoldenGate 11g官方文件Administrator’s Guide續一OracleGoGUIIDE
- mac提交svn提示CHECKOUT can only be performed on a version resourceMacORM
- TypeError: only integer scalar arrays can be converted to a scalar indexErrorIndex
- 錯誤處理--pure specifier can only be specified for functionsFunction
- Oracle Text Health Check (Doc ID 823649.1)Oracle
- Oracle GoldenGate Veridata 12.1.3OracleGo
- "Only fullscreen opaque activities can request orientation "問題再分析Opaque
- 【GoldenGate】Oracle GoldenGate Veridata 安裝配置與應用GoOracle
- Oracle 最新PSU (Doc ID 2118136.2)Oracle
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- "ScrollView can host only one direct child"問題解決View
- Only a type can be imported. classname resolves to a package的解決ImportPackage
- Swift代理報錯Optional can only be applied to members of an @objc protocolSwiftAPPOBJProtocol
- Oracle Column Group StatisticsOracle
- Oracle Grid/RAC 11.2.0.4 on Oracle Linux 7 (Doc ID 1951613.1)OracleLinux