Schema compare generates incorrect sync script for views (4331152)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

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
)
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;
***********************************************************
Cause

This issue is caused by a product defect.
Resolution

STATUS
waiting for a fix in the next release of Toad for Oracle.
Please note that this issue has been fixed in the latest Toad for Oracle Beta available through this link.
Defect ID

TOR-1961

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title