Feature suggestion - Partition comparison

[Jared Cooper]

When using "Compare User Objects", a few "Ignore..." options are available to ignore insignificant differences.

Please consider adding 'Ignore partition differences'.

When comparing schemas from a development database to a live database, many, if not all, the partitioned tables are listed as different when the only differences are the partitions themselves. Not a major issue, but useful to be able to ignore the partition differences.

Regards,

Jared

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Jared Cooper]

Great, thank you for considering this request.

Regards,

Jared

 

[Bernhard S]

The result in the differences tab is currently not working if you compare a partitioned table with a non-partitioned table. PL/SQL Developer then tries to just add the partitions using

ALTER TABLE ... ADD PARTITION .. ;

However you can only do that on a table that is already partitioned. If you try applying that to a non-partitioned table you get:

ORA-14501: object is not partitioned

I guess you would need to completely recreate the table partitioned in this case.

 

[Jared Cooper]

Hi Bernhard,

I agree, I would not expect PL/SQL Developer to be able to produce valid output if the source table is partitioned but not the destination (or vice versa).

However, in our case both source and destination tables are partitioned, it's just that the number of partitions is different due to the different sizes of the data contained within the table, so the ability to ignore the differences in the partitions themselves would solve this.

Thanks again for taking some time to review this issue.