Tiny little enhancement in Oracle Database 12.1.0.2:
The new CONTAINER clause to access data from different containers within one SQL statement. This may be very helpful, especially in case of schema consolidation. Similar things could have be done in Oracle 12.1.0.1 already by using database links – but resulting in way more complicated SQLs.
This is the new clause:
SELECT ename FROM CONTAINERS(scott.emp) WHERE CON_ID IN (45, 49);
See the documentation for more info about it.
–Mike
Hi
The containers clause has a bug, it error with ORA-600 if one of the columns is a LOB.
Test:
SQL> select * from containers(aud$);
select * from containers(aud$)
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkdoilsn2], [], [], [], [], [], [],
[], [], [], [], []
Cheers
Ned
Thanks 🙂
Mike
seems like using * (as in Select *) with containers clause causes the error ORA-00600. Specifying column name explicitly works
Just recapping:
I still receive the ORA-600 when selecting AUD$ regardless of the fact if I specify the schema or not. Still happens with the most recent PSU.
This works:
select count(*) from containers(obj$);
This fails:
select * from containers(sys.aud$);
ORA-00600: internal error code, arguments: [kkdoilsn2]
Hi,
oracle 12.2 and 19.3
PDB1, con_id=2, table SALES, owner=user1
PDB2, con_id=3, any user executing SELECT * FROM CONTAINERS(user1.sales) WHERE CON_ID =2;
show no rows.
Please check with Oracle Support – or even better, apply the most recent RU beforehand and then try again please.
Cheers
Mike