User does a Compare Schema on two schemas. The results show that a table exists on one schema but not on another, even though the table really does exist on both Schemas. Found that the tables differed in Supplemental Logging. Compare Schema should have listed the table as different, rather than missing.
For example:
In one schema, create the following table with a supplemental logging:
CREATE TABLE SL_TEST
(
ROW_ID VARCHAR2(15 CHAR) NOT NULL,
SUPPLEMENTAL LOG GROUP GGS_CX_DEALER_411455 (ROW_ID,CONFLICT_ID,DEALER_NUM) ALWAYS
)
In another schema, create the same table but without supplemental logging:
CREATE TABLE SL_TEST
(
ROW_ID VARCHAR2(15 CHAR) NOT NULL,
)
Do a Schema Compare. It will say that SL_TEST exists in the first schema but does not exist in the second schema.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center