schema compare Oracle

Answers

• Eddie D Redgate › Posts: 1,803 Rose Gold 5

  July 23, 2024 1:23PM

  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

  Eddie Davis
  Senior Product Support Engineer
  Redgate Software Ltd
  Email: support@red-gate.com

  0 · Share on Twitter
• Arie Posts: 5 New member

  July 24, 2024 1:11PM

  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?

  0 · Share on Twitter