The new Schema Compare in 12.11 generates an incorrect sync script for views, it does not include the column list. Example:
Script generated with legacy Schema Compare:***********************************************************
CREATE OR REPLACE VIEW SCOTT.EMP_DEPT
(
empno,
emp_name,
job,
mgr,
hiredate,
sal,
comm,
deptno,
dname
)
AS
SELECT
a.empno,
a.ename,
a.job,
a.mgr,
a.hiredate,
a.sal,
a.comm,
a.deptno,
b.dname
FROM
emp a,
dept b
WHERE
a.deptno = b.deptno
***********************************************************
Script generated with new Schema Compare:
***********************************************************
CREATE OR REPLACE VIEW SCOTT.EMP_DEPT
AS
SELECT
a.empno,
a.ename,
a.job,
a.mgr,
a.hiredate,
a.sal,
a.comm,
a.deptno,
b.dname
FROM
emp a,
dept b
WHERE
a.deptno = b.deptno;
***********************************************************