What are the challenges you face when working across database platforms? Take the survey
Options

The WHERE clause " is not well formed.

kevinjgoffkevinjgoff Posts: 4
edited December 17, 2010 10:03AM in Data Compare for Oracle
Just downloaded the data compare tool for evaluation.

During the Comparing database stage it appears to be comparing two tables, "Comparing tables XYZ and XYZ..." and i receive the following error:

The WHERE clause " is not well formed.

This table makeup is as follows:
X_ID NUMBER
XX_ID NUMBER
COMMENT VARCHAR2(4000 BYTE)
CREATED_ON TIMESTAMP(6)
CREATED_BY VARCHAR2(100 BYTE)
CREATED_BY_AID NUMBER

Comments

  • Options
    Hi Kevin,

    thanks for trying out the tool. Have you specified a WHERE Clause for the project? Would you be able to email through more details when the error occurs?

    Many thanks, Tom

    Tom Harris, Red Gate Software
Sign In or Register to comment.