Maxmix
Member³
Hi,
Having view on db1:
and slightly differently defined view u1.v1 on db2, I can successfully discover the difference via CompareUserObjects feature.
Applying SQL in target seems to be successful too.
However, in reality target db remains intact. I think, this is due to unusual comment in the end of view definition. Still the message about success in apply process is confusing. I hope you can fix it.
Having view on db1:
Code:
create or replace view u1.v1 as
select
....
where
........
----and eq.obj_id(+) = z.qjh_obj_id;and slightly differently defined view u1.v1 on db2, I can successfully discover the difference via CompareUserObjects feature.
Applying SQL in target seems to be successful too.
However, in reality target db remains intact. I think, this is due to unusual comment in the end of view definition. Still the message about success in apply process is confusing. I hope you can fix it.
Last edited:
