COMPARE SCHEMA is not work properly in TOAD 2026 R2

Toad for Oracle & DevOps Toolkit
1

Running in the same environment and comparing 2 ORACLE , TOAD 20256 R1 show differences that really are there but TOAD 2026 R2 can´t found the differences.

This is the compare results in R2:

image
image1353×675 50.1 KB

and this is the compare results in R1:

image
image886×441 125 KB

image
image886×378 124 KB

Definition in DEV:

DROP TABLE CRM_ALIVE.ALIVE_EN_PATRIMONIO_STATUS CASCADE CONSTRAINTS;

CREATE TABLE CRM_ALIVE.ALIVE_EN_PATRIMONIO_STATUS
(
CD_CUSTOMER INTEGER NOT NULL,
CD_PATRIMONIO_STATUS INTEGER NOT NULL,
NM_PATRIMONIO_STATUS VARCHAR2(20 CHAR) NOT NULL,
NR_PRIORIDADE INTEGER DEFAULT 0 NOT NULL,
TX_COR_FONTE VARCHAR2(10 BYTE) DEFAULT NULL,
TX_COR_BACKGROUND VARCHAR2(10 BYTE) DEFAULT NULL,
DS_PATRIMONIO_STATUS VARCHAR2(100 BYTE) DEFAULT NULL,
FL_STATUS_INICIAL CHAR(1 BYTE) DEFAULT 'N' NOT NULL,
FL_STATUS_FINAL CHAR(1 BYTE) DEFAULT 'N' NOT NULL
)
TABLESPACE CRM_ALIVE_BAS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE;

CREATE UNIQUE INDEX CRM_ALIVE.PK_ALIVE_STATUS_PATRIMONIO ON CRM_ALIVE.ALIVE_EN_PATRIMONIO_STATUS
(CD_CUSTOMER, CD_PATRIMONIO_STATUS)
LOGGING
TABLESPACE CRM_ALIVE_BAS_IX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
);

ALTER TABLE CRM_ALIVE.ALIVE_EN_PATRIMONIO_STATUS ADD (
CONSTRAINT CK_ALIVE_PATR_FL_STATUS_FIM
CHECK (FL_STATUS_FINAL IN ('N','S'))
ENABLE VALIDATE
, CONSTRAINT CK_ALIVE_PATR_FL_STATUS_INI
CHECK (FL_STATUS_INICIAL IN ('N','S'))
ENABLE VALIDATE
, CONSTRAINT PK_ALIVE_STATUS_PATRIMONIO
PRIMARY KEY
(CD_CUSTOMER, CD_PATRIMONIO_STATUS)
USING INDEX CRM_ALIVE.PK_ALIVE_STATUS_PATRIMONIO
ENABLE VALIDATE);

ALTER TABLE CRM_ALIVE.ALIVE_EN_PATRIMONIO_STATUS ADD (
CONSTRAINT FK_ALIVE_STATUS_PATRIM_CUSTOM
FOREIGN KEY (CD_CUSTOMER)
REFERENCES CRM_ALIVE.SEC_EN_CUSTOMER (CD_CUSTOMER)
ENABLE VALIDATE);

Definition in SANDBOX_18:

DROP TABLE CRM_ALIVE.ALIVE_EN_PATRIMONIO_STATUS CASCADE CONSTRAINTS;

CREATE TABLE CRM_ALIVE.ALIVE_EN_PATRIMONIO_STATUS
(
CD_CUSTOMER INTEGER NOT NULL,
CD_PATRIMONIO_STATUS INTEGER NOT NULL,
NM_PATRIMONIO_STATUS VARCHAR2(20 CHAR) NOT NULL,
NR_PRIORIDADE INTEGER DEFAULT 0 NOT NULL,
FL_STATUS_INICIAL CHAR(1 BYTE) DEFAULT 'N' NOT NULL,
FL_STATUS_FINAL CHAR(1 BYTE) DEFAULT 'N' NOT NULL,
TX_COR_FONTE VARCHAR2(10 BYTE) DEFAULT NULL,
TX_COR_BACKGROUND VARCHAR2(10 BYTE) DEFAULT NULL,
DS_PATRIMONIO_STATUS VARCHAR2(100 BYTE) DEFAULT NULL
)
TABLESPACE CRM_ALIVE_BAS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE;

CREATE UNIQUE INDEX CRM_ALIVE.PK_ALIVE_STATUS_PATRIMONIO ON CRM_ALIVE.ALIVE_EN_PATRIMONIO_STATUS
(CD_CUSTOMER, CD_PATRIMONIO_STATUS)
LOGGING
TABLESPACE CRM_ALIVE_BAS_IX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
PCTINCREASE 0
BUFFER_POOL DEFAULT
);

ALTER TABLE CRM_ALIVE.ALIVE_EN_PATRIMONIO_STATUS ADD (
CONSTRAINT CK_ALIVE_PATR_FL_STATUS_FIM
CHECK (FL_STATUS_FINAL IN ('N','S'))
ENABLE VALIDATE
, CONSTRAINT CK_ALIVE_PATR_FL_STATUS_INI
CHECK (FL_STATUS_INICIAL IN ('N','S'))
ENABLE VALIDATE
, CONSTRAINT PK_ALIVE_STATUS_PATRIMONIO
PRIMARY KEY
(CD_CUSTOMER, CD_PATRIMONIO_STATUS)
USING INDEX CRM_ALIVE.PK_ALIVE_STATUS_PATRIMONIO
ENABLE VALIDATE);

ALTER TABLE CRM_ALIVE.ALIVE_EN_PATRIMONIO_STATUS ADD (
CONSTRAINT FK_ALIVE_STATUS_PATRIM_CUSTOM
FOREIGN KEY (CD_CUSTOMER)
REFERENCES CRM_ALIVE.SEC_EN_CUSTOMER (CD_CUSTOMER)
ENABLE VALIDATE);

2

Hi Luishmr,

Thank you for the detailed post and table script. I am able to reproduce this and will fix it in the the beta version

-John