Re: How get current container DBID using sys_context ('userenv'?

Thanks for your reply. I resolved myself. Using CON_DBID. This is also a column on V$DATABASE. I was not aware of this till few minutes ago... :-D

On CDB:

*U71013576_at_P11CDB6.ecc03cas06vm01 [18c RAC] r 1 select 2 sys_context

('userenv','CON_DBID')       CON_DBID,  3  sys_context
('userenv','DB_NAME')        DB_NAME,  4  sys_context ('userenv','DBID')
        DBID,  5  sys_context ('userenv','DB_UNIQUE_NAME') DB_UNIQUE_NAME
6* from dualCON_DBID             DB_NAME              DBID
DB_UNIQUE_NAME-------------------- --------------------
-------------------- --------------------2416754358           P11CDB
        2416754358           P11CDB*

On PDB:

*U71013576_at_P00NGP/P11CDB6.ecc03cas06vm01 [18c RAC] r 1 select 2

 sys_context ('userenv','CON_DBID')       CON_DBID,  3  sys_context
('userenv','DB_NAME')        DB_NAME,  4  sys_context ('userenv','DBID')
        DBID,  5  sys_context ('userenv','DB_UNIQUE_NAME') DB_UNIQUE_NAME
6* from dualCON_DBID             DB_NAME              DBID
DB_UNIQUE_NAME-------------------- --------------------
-------------------- --------------------630270457            P00NGP
        2416754358           P11CDB*

Em seg, 30 de set de 2019 às 15:52, Mladen Gogala <gogala.mladen_at_gmail.com> escreveu:

> I would not use DBID column for PDB databases. I would use GUID column
> which is guaranteed to be unique.
> On 9/30/19 1:13 PM, Luis Claudio Dias dos Santos wrote:
>
> Hi
>
> I have a CDB with two PDBS.
>
> U71013576_at_P11CDB6.ecc03cas06vm01 [18c RAC] select sys_context
> ('userenv','CON_NAME') from dual;
>
> SYS_CONTEXT('USERENV','CON_NAME')
>
> ---------------------------------------------------------------------------------------------------
> CDB$ROOT
>
> In other words: ('userenv','DBID') is not following
> ('userenv','DB_NAME'), but ('userenv','DB_UNIQUE_NAME').
>
>
>
>
> You can adopt unique names. I have an inexhaustible reservoir of DB names:
> "NANCY", "MITCH", "ADAM", "AOC","LINDSAY","ILHAN", "RAND". You can combine
> them as you like. The funny thing is that when I get sick of these names, I
> will get another batch. Every 2 years the set gets renewed.
>

--
http://www.freelists.org/webpage/oracle-l