The WHERE clause " is not well formed.

Compares and synchronizes Oracle data

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

The WHERE clause " is not well formed.

Postby kevinjgoff » Thu Dec 16, 2010 5:59 pm

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
kevinjgoff
 
Posts: 2
Joined: Fri Mar 14, 2008 7:34 pm

Postby Tom Harris » Fri Dec 17, 2010 4:03 pm

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
Tom Harris
 
Posts: 308
Joined: Wed Oct 06, 2004 3:45 pm


Return to Data Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests