Command Line does not recognize the Secondary Unique Index

Command Line does not recognize the Secondary Unique Index

Postby NavilleD » Thu 07 May 2015 14:15

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.
NavilleD
 
Posts: 6
Joined: Tue 03 Mar 2015 21:33

Re: Command Line does not recognize the Secondary Unique Index

Postby alexa » Thu 07 May 2015 15:27

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
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17

Re: Command Line does not recognize the Secondary Unique Index

Postby NavilleD » Thu 07 May 2015 19:16

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
NavilleD
 
Posts: 6
Joined: Tue 03 Mar 2015 21:33

Re: Command Line does not recognize the Secondary Unique Index

Postby alexa » Fri 08 May 2015 11:48

You can send the scripts to supportATdevartDOTcom and alexaATdevartDOTcom

Also, please provide us the command line string and the *.dcomp document.
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle