Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Question about oracle 12c container's temp tablespace list

user12187546Jul 12 2013 — edited Jul 14 2013

select con_id, name From v$containers;  ---> 4 rows returned.

1CDB$ROOT
2PDB$SEED
3PDBRED
4

PDBBLUE

select con_id, name  From v$tempfile;  ---> 4 rows returned.

1/u01/app/oracle/oradata/cdb1/temp01.dbf
2/u01/app/oracle/oradata/cdb1/pdbseed/pdbseed_temp01.dbf
3/u01/app/oracle/oradata/cdb1/pdbred/temp01.dbf
4

/u01/app/oracle/oradata/cdb1/pdbblue/pdbseed_temp01.dbf

select CON_ID, TABLESPACE_NAME from cdb_tablespaces where TABLESPACE_NAME like 'TEMP%';   ---> 4 rows returned.

4TEMP
3TEMP
2TEMP
1

TEMP

select * from v$temp_space_header; <---------- why return only one row ???

1

TEMP

12c 's bug?
This post has been answered by Stefan Koehler on Jul 13 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 11 2013
Added on Jul 12 2013
#general-database-discussions
12 comments
1,893 views