Tiny little enhancement in Oracle Database 220.127.116.11:
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 18.104.22.168 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.
The containers clause has a bug, it error with ORA-600 if one of the columns is a LOB.
SQL> select * from containers(aud$);
select * from containers(aud$)
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkdoilsn2], , , , , , ,
, , , , 
seems like using * (as in Select *) with containers clause causes the error ORA-00600. Specifying column name explicitly works
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.
select count(*) from containers(obj$);
select * from containers(sys.aud$);
ORA-00600: internal error code, arguments: [kkdoilsn2]
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.