Hi All,
In 12.1.0.2.0 I created a container DB named cont12c with 3 pluggable databases (named plug12c1,plug12c2 and plug12c3).
Each PDB has its own set of datafiles and temp files, both the views cdb_data_files and v$datafile were showing same result.
Then I converted 1 non-cdb to pdb using dbms_pdb.describe () package and noncdb_to_pdb.sql script and name of this pdb was pdb_db12c.
Then I cloned pdb_db12c to pdb_db12c_clone (it accepted more than 8 chars in DB name) inside same container.
Now my container DB "cont12c" has 5 pluggable DBs.
SQL> sho con_name;
CON_NAME
--------------------------------
CDB$ROOT
SQL>select con_id,open_mode from v$pdbs;
CON_ID OPEN_MODE
-----------------------------------------
2 READ ONLY
3 READ WRITE
4 READ WRITE
5 READ WRITE
6 READ WRITE
7 READ WRITE
6 rows selected.
SQL > alter session set container=pdb_db12c;
Session altered.
SQL> sho con_name;
CON_NAME
------------------
PDB_DB12C
SQL> create table test_table as select * from sys.obj$;
TABLE CREATED.
SQL> conn / as sysdba
connected.
SQL> sho con_name;
CON_NAME
--------------------------------
CDB$ROOT
SQL> select file_name from cdb_data_files; ----- (sorry, can not write O/P here as not able to copy from gurst OS to host OS).
FILE_NAME
-----------------------------------
4 files of CDB database.
3 files of plug12c1
3 files of plug12c2
3 files of plug12c3
13 rows selected.
SQL> select name from v$datafile;
NAME
--------------------
6 files of CDB ( 2 sysaux and 2 system tablespace files) --- ( both having status as online ,though dba_data_files showing only 1 datafile for both)
3 files of plug12c1
3 files of plug12c2
3 files of plug12c3
3 files of pdb_db12c
3 files of pdb_db12c_clone
21 rows selected.
I restarted the container DB but no luck.
Same issue for cdb_temp_files and v$tempfile, not able to see files of 4th and 5th PDB in cdb_* view.
Kindly help.