Hi,
What is the privilege (other than SYSDBA) that enables usage of function CONTAINERS() ?
QUERY USING USER SYSTEM ON 12.1 FAILS:
$ sqlplus system@l0db007
SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 9 11:32:26 2018
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics,
Real Application Testing and Unified Auditing options
SQL> select * from containers(GLOBAL_NAME);
select * from containers(GLOBAL_NAME)
*
ERROR at line 1:
ORA-00942: table or view does not exist
QUERY USING USER SYS AS SYSDBA ON 12.1 SUCCEEDS:
$ sqlplus sys@l0db007 as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 9 11:33:26 2018
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics,
Real Application Testing and Unified Auditing options
SQL> select * from containers(GLOBAL_NAME);
GLOBAL_NAME CON_ID
----------------- ------
LAB_EMREPO.XXX.YY 3
L0DB007.XXX.YY 1
2 rows selected.
QUERY USING USER SYSTEM ON 12.2 SUCCEEDS:
$ sqlplus system@l0db008
SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 9 11:35:44 2018
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select * from containers(GLOBAL_NAME);
GLOBAL_NAME CON_ID
--------------- ------
L0DB008.XXX.YY 1
L0PDB008.XXX.YY 3
2 rows selected.
Regards,
Marek