Goldengate error on table with primary key
0
Installed Goldengate Version 18.1.0.0.0 for Oracle 11gR2. Table has primary key and yet goldengate complains that there is no key found,see below
GGSCI (server01.localdomain as gguser@UPGR) 3> add trandata scott.books
2019-01-23 22:44:42 WARNING OGG-06439 No unique key is defined for table BOOKS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2019-01-23 22:44:42 INFO OGG-15130 No key found for table SCOTT.BOOKS. All viable columns will be logged.
2019-01-23 22:44:42 INFO OGG-15135 TRANDATA for instantiation CSN has been added on table SCOTT.BOOKS`
GGSCI (server01.localdomain as gguser@UPGR) 10> info trandata scott.books
Logging of supplemental redo log data is enabled for table SCOTT.BOOKS.
Columns supplementally logged for table SCOTT.BOOKS: "AUTHOR", "ID", "LANGUAGE_ID", "TITLE", "YEAR_PUBLISHED".
Prepared CSN for table SCOTT.BOOKS: 978016
This is DDL of scott.books from Oracle SQL Developer
CREATE TABLE "SCOTT"."BOOKS"
("ID" NUMBER(*,0),
"TITLE" VARCHAR2(26 BYTE),
"AUTHOR" VARCHAR2(23 BYTE),
"YEAR_PUBLISHED" NUMBER(*,0),
"LANGUAGE_ID" NUMBER(*,0),
CONSTRAINT "PK_ID" PRIMARY KEY ("ID")
)
Can someone point me in right direction.
Thanks
oracle oracle-11g-r2 goldengate
asked 3 mins ago
KumarKumar
11
New contributor
Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
0
Installed Goldengate Version 18.1.0.0.0 for Oracle 11gR2. Table has primary key and yet goldengate complains that there is no key found,see below
GGSCI (server01.localdomain as gguser@UPGR) 3> add trandata scott.books
2019-01-23 22:44:42 WARNING OGG-06439 No unique key is defined for table BOOKS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2019-01-23 22:44:42 INFO OGG-15130 No key found for table SCOTT.BOOKS. All viable columns will be logged.
2019-01-23 22:44:42 INFO OGG-15135 TRANDATA for instantiation CSN has been added on table SCOTT.BOOKS`
GGSCI (server01.localdomain as gguser@UPGR) 10> info trandata scott.books
Logging of supplemental redo log data is enabled for table SCOTT.BOOKS.
Columns supplementally logged for table SCOTT.BOOKS: "AUTHOR", "ID", "LANGUAGE_ID", "TITLE", "YEAR_PUBLISHED".
Prepared CSN for table SCOTT.BOOKS: 978016
This is DDL of scott.books from Oracle SQL Developer
CREATE TABLE "SCOTT"."BOOKS"
("ID" NUMBER(*,0),
"TITLE" VARCHAR2(26 BYTE),
"AUTHOR" VARCHAR2(23 BYTE),
"YEAR_PUBLISHED" NUMBER(*,0),
"LANGUAGE_ID" NUMBER(*,0),
CONSTRAINT "PK_ID" PRIMARY KEY ("ID")
)
Can someone point me in right direction.
Thanks
oracle oracle-11g-r2 goldengate
asked 3 mins ago
KumarKumar
11
New contributor
Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
0
0
0
Installed Goldengate Version 18.1.0.0.0 for Oracle 11gR2. Table has primary key and yet goldengate complains that there is no key found,see below
GGSCI (server01.localdomain as gguser@UPGR) 3> add trandata scott.books
2019-01-23 22:44:42 WARNING OGG-06439 No unique key is defined for table BOOKS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2019-01-23 22:44:42 INFO OGG-15130 No key found for table SCOTT.BOOKS. All viable columns will be logged.
2019-01-23 22:44:42 INFO OGG-15135 TRANDATA for instantiation CSN has been added on table SCOTT.BOOKS`
GGSCI (server01.localdomain as gguser@UPGR) 10> info trandata scott.books
Logging of supplemental redo log data is enabled for table SCOTT.BOOKS.
Columns supplementally logged for table SCOTT.BOOKS: "AUTHOR", "ID", "LANGUAGE_ID", "TITLE", "YEAR_PUBLISHED".
Prepared CSN for table SCOTT.BOOKS: 978016
This is DDL of scott.books from Oracle SQL Developer
CREATE TABLE "SCOTT"."BOOKS"
("ID" NUMBER(*,0),
"TITLE" VARCHAR2(26 BYTE),
"AUTHOR" VARCHAR2(23 BYTE),
"YEAR_PUBLISHED" NUMBER(*,0),
"LANGUAGE_ID" NUMBER(*,0),
CONSTRAINT "PK_ID" PRIMARY KEY ("ID")
)
Can someone point me in right direction.
Thanks
oracle oracle-11g-r2 goldengate
asked 3 mins ago
KumarKumar
11
New contributor
Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Installed Goldengate Version 18.1.0.0.0 for Oracle 11gR2. Table has primary key and yet goldengate complains that there is no key found,see below
GGSCI (server01.localdomain as gguser@UPGR) 3> add trandata scott.books
2019-01-23 22:44:42 WARNING OGG-06439 No unique key is defined for table BOOKS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2019-01-23 22:44:42 INFO OGG-15130 No key found for table SCOTT.BOOKS. All viable columns will be logged.
2019-01-23 22:44:42 INFO OGG-15135 TRANDATA for instantiation CSN has been added on table SCOTT.BOOKS`
GGSCI (server01.localdomain as gguser@UPGR) 10> info trandata scott.books
Logging of supplemental redo log data is enabled for table SCOTT.BOOKS.
Columns supplementally logged for table SCOTT.BOOKS: "AUTHOR", "ID", "LANGUAGE_ID", "TITLE", "YEAR_PUBLISHED".
Prepared CSN for table SCOTT.BOOKS: 978016
This is DDL of scott.books from Oracle SQL Developer
CREATE TABLE "SCOTT"."BOOKS"
("ID" NUMBER(*,0),
"TITLE" VARCHAR2(26 BYTE),
"AUTHOR" VARCHAR2(23 BYTE),
"YEAR_PUBLISHED" NUMBER(*,0),
"LANGUAGE_ID" NUMBER(*,0),
CONSTRAINT "PK_ID" PRIMARY KEY ("ID")
)
Can someone point me in right direction.
Thanks
oracle oracle-11g-r2 goldengate
oracle oracle-11g-r2 goldengate
asked 3 mins ago
KumarKumar
11
New contributor
Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 3 mins ago
KumarKumar
11
New contributor
Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 3 mins ago
KumarKumar
11
New contributor
Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 3 mins ago
KumarKumar
11
asked 3 mins ago
KumarKumar
11
11
New contributor
Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Kumar is a new contributor. Be nice, and check out our Code of Conduct.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f227904%2fgoldengate-error-on-table-with-primary-key%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Kumar is a new contributor. Be nice, and check out our Code of Conduct.
draft saved
draft discarded
Kumar is a new contributor. Be nice, and check out our Code of Conduct.
Kumar is a new contributor. Be nice, and check out our Code of Conduct.
Kumar is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f227904%2fgoldengate-error-on-table-with-primary-key%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
