Oracle GoldenGate: Knowledge Document Series Post #1
- by Doug Reid
0
false
18 pt
18 pt
0
0
false
false
false
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-ascii-font-family:Cambria;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"Times New Roman";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Cambria;
mso-hansi-theme-font:minor-latin;}
Over the course of the next
several weeks, the Oracle GoldenGate team will be posting highlights from the
knowledge base on My Oracle Support. The intent is to bring greater awareness to our
user community of some fantastic best practices documents that are available to anyone with a valid CSI. These documents were originally created for our internal teams, but the content was so good and useful that we have made them available externally for our user community.
The first in our series is
the Oracle GoldenGate database Schema Profile check script (Doc ID
1296168.1).
“This
script is intended to query the database by schema to identify current
configuration and identify any unsupported data types or types that may need
special considerations for Oracle GoldenGate in an Oracle environment. This is
the Oracle database profile script. Added check for deferred constraints.
Deferred constraints may cause ADD TRANDATA to select the wrong column for
logging. Use KEYCOLS for tables with deferred constraints.”
Click here to view
the document
Check back weekly for additional new postings.