Hi,
There’s an issue when comparing tables if one table is partitioned and the other isn’t. When you compare them, the partitions don’t appear in the comparison results at all. Am I missing something?
Please provide more details as to how to reproduce the problem. Screen shots are helpful too.
It is simple to reproduce.
Just take one partitioned table and compare to another table without any partitions.
Display both tables in the Schema Browser, select one of the tables, right-click it, choose Compare, and compare it to the other table.
For example:
Table 1:
CREATE TABLE compare_ex
(
REQUEST_RECEIVED_TIME DATE NOT NULL,
DATE_CREATED DATE NOT NULL
);
Table 2:
CREATE TABLE compare_ex_partition
(
REQUEST_RECEIVED_TIME DATE NOT NULL
)
PARTITION BY RANGE (REQUEST_RECEIVED_TIME)
INTERVAL (NUMTODSINTERVAL(1,'DAY'))
(
PARTITION P_INIT VALUES LESS THAN (TO_DATE(' 2025-12-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
);
It is simple to reproduce.
Just take one partitioned table and compare to another table without any partitions.
For example:
Table 1:
CREATE TABLE compare_ex
(
REQUEST_RECEIVED_TIME DATE NOT NULL,
DATE_CREATED DATE NOT NULL
);
Table 2:
CREATE TABLE compare_ex_partition
(
REQUEST_RECEIVED_TIME DATE NOT NULL
)
PARTITION BY RANGE (REQUEST_RECEIVED_TIME)
INTERVAL (NUMTODSINTERVAL(1,'DAY'))
(
PARTITION P_INIT VALUES LESS THAN (TO_DATE(' 2025-12-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
);
Did you see my last post? I believe that you aren't seeing partitions differences because you have the Partition option unchecked.
1 Like
I missed your post.
Great answer!
Again I looked for any related settings in the Toad options and I didn’t realize that there are many TOAD settings scattered across different locations.