Devart Forums

Hi,

I am working with DBForge for Oracle, I came across this strange issue while I had a Table which had 2 Unique Indexes, So now I have a .DCOMP for each Index, when I see the results from the UI. It seems like it is doing what is desired (using the respective index) whereas when I run it through command line, it does not seem to recognize the second index and ends up giving same report for both the .dcomps.

Please help me understand why thisis happening and if there is any solution to taht please let me know.

Could you please provide us a screenshot of the error and the CREATE definitions of the table for both Source an Target?

You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom

I do not get any error the comparison runs fine, however the Secondary Unique Index is not being used, while I run through the Command Line.

Here is the Example:
I have a table named ITEM which has 2 unique indexes, ITEM_NDX1 and ITEM_NDX2, so in order to compare the table, I have 2 different dcomp files, and When I run them throught the DBFORGE tool, I get different results(which is right), and then when I run them through the command line, I get the same results for both the runs.

The Secondary Unique index is not being recognized, I dont know whether I can send the Scripts here or not

You can send the scripts to supportATdevartDOTcom and alexaATdevartDOTcom

Also, please provide us the command line string and the *.dcomp document.