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.
STATUS:
Waiting for fix in a future release of Toad for Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center