1. Create comments on the columns of a VIEW in the database (Oracle XE 18.104.22.168.0)
2. Use schema compare v22.214.171.1249 to generate scripts - runs OK
3. Use schema compare v126.96.36.1999 to re-create objects in database schema from scripts - FAILS
The Schema Compare run in step 3 fails when running deployment script with "Error: ORA-00911: invalid character"
Removing the "comment on column view.column is '...'" commands from the "create view" script seems to fix the problem - so assume that these comments are the cause of the problem.
Could someone please confirm whether
(1) This is a bug?
(2) When we can expect a new version of Schema Compare that fixes this (and the 2 previously reported bugs)?