schema compare Oracle

Arie

How to deal with range partitions meaning ignore auto partitions when comparing existing tables.

Eddie D

Hi Arie, thank you for your forum post.

By default, Schema Compare for Oracle will ignore all storage options.

If you edit your Schema Compare for Oracle -> Select the Options tab -> Include storage section, no options are selected.  Plus in the Ignore section system partitions and lob storage options are greyed out and disabled.

If you select the following Include storage options:
all storage options
partitioning
tablespaces

The system partitions and lob storage options are then enabled in the Ignore section and the user can then choose to Ignore by checking the check box.

If just the lobs and arrays Include storage option is selected.  The lob storage option is enabled in the Ignore section and the user can then choose to Ignore lob storage by checking the check box.

Does the above above answer your question?

Many Thanks
Eddie

Arie

Thanks for your response. The problem here is that the ingnore system partitions is tricky... first it does not work correctly with hash partition and second it seems to not apply ignore system partitions to the database date when compared to a git data built with ignore system partitions. do I miss something here?