Return
-
Title
Schema compare generates incorrect sync script for views -
Description
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)ASSELECTa.empno,a.ename,a.job,a.mgr,a.hiredate,a.sal,a.comm,a.deptno,b.dnameFROMemp a,dept bWHEREa.deptno = b.deptno***********************************************************
***********************************************************
Script generated with new Schema Compare:
CREATE OR REPLACE VIEW SCOTT.EMP_DEPTASSELECTa.empno,a.ename,a.job,a.mgr,a.hiredate,a.sal,a.comm,a.deptno,b.dnameFROMemp a,dept bWHEREa.deptno = b.deptno;***********************************************************
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.