Oracle Database 12c
Red Hat Linux 6.5
Hi,
I have create a database with CDB enabled. By default, a sales pluggable database was created. I am creating a new pluggable database using
CREATE PLUGGABLE DATABASE HR ADMIN USER ABC IDENTIFIED BY ***
STORAGE (MAXSIZE 2G)
DEFAULT TABLESPACE users
DATAFILE '/opt/cbd2/oradata/MCDB/HR/sales01.dbf' SIZE 250M AUTOEXTEND ON
PATH_PREFIX = '/opt/cbd2/oradata/MCDB/HR/'
FILE_NAME_CONVERT = ('/opt/cbd2/oradata/MCDB/datafile/', '/opt/cbd2/oradata/MCDB/HR/');
CREATE PLUGGABLE DATABASE HR ADMIN USER *** IDENTIFIED BY ***
*
ERROR at line 1:
ORA-01276: Cannot add file
/opt/cbd2/oradata/MCDB/HR/o1_mf_system_dpp7f77b_.dbf. File has an Oracle
Managed Files file name.
I am getting error above.
One thing I noticed is I cannot find the files for PDB$SEED
SQL> select name from v$pdbs;
NAME
------------------------------
PDB$SEED
SALES
In the FILE_NAME_CONVERT clause, how do I know the files and locations for PDB$SEED?
Thanks,
Joe