Skip to Main Content

Oracle 12.1.0.2; select * from containers(GLOBAL_NAME); Requires SYSDBA?

Marek LällApr 9 2018 — edited May 3 2018

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

Comments
Post Details
Added on Apr 9 2018
7 comments
4,812 views