Activity overview
Latest activity by jonnoct
Manage DBMS_RESULT_CACHE during migrations
Hi all,
With the new versions of Oracle if you need to migrate a patch to a live system you need to add code to the migration script to prevent the result cache from returning incorrect results. S...
Thanks Richard,
Support has been very responsive and I have sent in a simpler example. I'll post it here just in case anyone is curious. drop type hr.department_t force;
drop type hr.employee_tbl_t force;
drop type hr.employee_t force;
/
create type hr.employee_t as object
(
id_num number ( 6, 0 ),
first_name varchar2 ( 20 ),
last_name varchar2 ( 25 )
);
/
create type hr.employee_tbl_t as table of hr.employee_t;
/
create type hr.department_t as object
(
id_num number ( 4, 0 ),
name varchar2 ( 30 ),
employees employee_tbl_t
);
/
create or replace view hr.departments_v of hr.department_t
with object identifier ( id_num ) as
select
d.department_id,
d.department_name,
cast ( multiset (
select
e.employee_id,
e.first_name,
e.last_name
from
hr.employees e
where
e.department_id = d.department_id
)
as hr.employee_tbl_t )
from
hr.departments d;
/
select type_text, oid_text as object_identifier_text from dba_views where owner = 'HR' and view_name = 'DEPARTMENTS_V';
Since TYPE_TEXT is not null Schema Compare should be using the OBJECT_VIEW_CLAUSE (https://docs.oracle.com/database/121/SQ ... m#i2122282)
TYPE_TEXT OBJECT_IDENTIFIER_TEXT
hr.department_t id_num / comments
Thanks Richard,
Support has been very responsive and I have sent in a simpler example. I'll post it here just in case anyone is curious.drop type hr.department_t force;
drop type hr.employee_tbl_t...
Object Views Not Compared Correctly
Morning,
Schema Compare for Oracle 3.1.0.137 isn't comparing object views correctly.http://docs.oracle.com/cd/B19306_01/app ... #sthref663
For example here's what DBMS_METADATA will produce...
CREA...