Options
Command Line Data difference in Oracle using wildcards
Shaheer
Posts: 15 New member
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"^|"Table"
will include:
MyTable MyTable1 MyTable2
but i only want MyTable. how can i achieve this using command line in oracle?
So for example this
/Include:"MyTable"^|"Table"
will include:
MyTable MyTable1 MyTable2
but i only want MyTable. how can i achieve this using command line in oracle?
Answers
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
Have you visited our Help Center?
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?
We might need to use an "Ignore" rule to achieve this. Can you try the following?
/Include:^MyTable$
Regards,
David Harris | Product Support Engineer
Have you visited our Help Center?