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
Eddie Davis Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
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?
Answers
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com