Issue when trying to compare scripts folder with database

ugzas

Hi, i have tried to do compare from scripts folder to database, and i am getting this error:

Parsing failed with message SyntaxError. Unexpected token ',' (Line 14, Col 25) symbol.

Maybe you can help why i am getting this error. I only get this, when in PARTITION BY LIST there is more than one value separated by comma. But tried to run this script in database, everything works without any errors

Eddie D

Hi Ugzas,
Thank you for your reply.

As you are using V6.0.2.143, I recommend that you upgrade to V6.0.3 or higher.  The latest version is V6.0.10 released earlier today.

The release notes for Schema Compare for Oracle, available here, indicate that a bug fix  for a parsing error for list partitions with multi-column names was added back in version V6.0.3.

I have tested using the latest version V6.0.10 and I am unable to reproduce the reported problem.

To upgrade, please run the check for updates mechanism from the Help menu -> Check for updates. 

Many Thanks
Eddie

ugzas

CREATE TABLE test.test (

  test1 DATE NOT NULL,

  test2 VARCHAR2(20 CHAR),

  test3 VARCHAR2(1 CHAR) NOT NULL,

  test4 VARCHAR2(70 CHAR) NOT NULL,

  test5 VARCHAR2(10 CHAR),

  test6 NUMBER,

  test7 NUMBER,

  test8 NUMBER,

  test9 NUMBER,

  test10 VARCHAR2(2 CHAR),

  test11 NUMBER

)

PARTITION BY LIST (test1,test2,test3)

(PARTITION init_part VALUES (( null, null, null ))

  INDEXING ON);


Here is script

Eddie D

Hi,
Thank you for your forum post.  Can you please confirm the exact full version number of Schema Compare for Oracle you are using?  You can obtain this from the Help menu in the GUI and selecting the About option.

ugzas

Eddie D said:

Hi,
Thank you for your forum post.  Can you please confirm the exact full version number of Schema Compare for Oracle you are using?  You can obtain this from the Help menu in the GUI and selecting the About option.

Hi, version number is 6.0.2.143