Hi,
I have an Oracle RDBMS 12c.
I have a set f containers:
Container Totaal
name Container Container Open Open size Recovery
(PDB) ID DBID UID mode Restrict time (MB) status
--------------- ---------- ------------- ------------- ------------ -------- ------------------- ---------------- ----------
CDB$ROOT 1 3129040689 1 READ WRITE NO 2015/09/27:09:18;06 0 ENABLED
PDB$SEED 2 550179998 550179998 READ ONLY NO 2015/09/27:09:18;06 1,010 ENABLED
FREYA 3 1738182686 1738182686 READ WRITE YES 2015/09/27:09:19;41 2,496 ENABLED
ODIN 4 4236311420 4236311420 READ WRITE YES 2015/09/27:09:19;41 1,050 ENABLED
LOKKI 5 3332235708 3332235708 READ WRITE YES 2015/09/27:09:19;41 1,050 ENABLED
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> alter session set container=LOKKI;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
LOKKI
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
-----------------------------------
SYSTEM
SYSAUX
TEMP
SQL> alter session set container=CDB$ROOT;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
select
con_id,
tablespace_name
from
cdb_tablespaces;
Container
ID TABLESPACE_NAME
---------- -----------------------------------
1 SYSTEM
1 SYSAUX
1 UNDOTBS1
1 TEMP
1 USERS
1 APEX500_USER_D
1 APEX500_FILES_D
How to view at once, all the tablespaces for each container?
Thanks and Regards