Command Line Data difference in Oracle using wildcards

• 
  waiting for response!!

  Shaheer May 24, 2021 10:45

  - 0 +
• 

  Hi Muhammad,

  Thank you for raising your query with Redgate Support through our Forum.  I've also raised a support ticket for this to track the conversation. 
  

  Looking at the statement you are using:
  

  /Include:"MyTable"^|"Table"
  

  the "|" is representative of an OR statement.  By including the |"Table" you are asking to include names that are specifically "MyTable" OR have "Table" in the name.

  simply using 

  /Include:"MyTable" 
  

  should work

  https://documentation.red-gate.com/dco/using-the-command-line/command-line-examples
  

  You can use the Ignore Rules Filter to select the Table required:

  https://documentation.red-gate.com/dco/setting-up-the-comparison/using-ignore-rules
  

  https://documentation.red-gate.com/sco5/setting-up-the-comparison/using-ignore-rules/ignore-rules-syntax-and-examples
  

  
  

  Regards,

  David Harris | Product Support Engineer

  DavidHarris May 26, 2021 08:06

  - 0 +
• 
  When I use the following options in a command line execution to find Data Difference in Oracle using data compare for oracle, it includes all tables beginning with the specified table name.
  
  So for example this
  /Include:"MyTable"
  
  output:
  MyTable MyTable1 MyTable2
  
  but i only want MyTable. how can i achieve this using command line in oracle?
  

  Shaheer May 27, 2021 07:45

  - 0 +
• 
  can someone answer my above query?

  Shaheer June 01, 2021 05:56

  - 0 +
• 
  Hi Muhammad,
  
  We might need to use an "Ignore" rule to achieve this.  Can you try the following?
  
  /Include:^MyTable$
  
  Regards,
  David Harris | Product Support Engineer
  

  DavidHarris June 11, 2021 04:45

  - 0 +

Add comment

Please sign in to leave a comment.