Hi there,
I have the oracle 12c r2 installed, and would like to create another pluggable database on another drive, i.e. an usb drive. I tried the following ways -
1). Creating a PDB by Using the Seed;
code:
create pluggable database PDBCDB2 admin user testuser identified by testuserpwd
DEFAULT TABLESPACE USERS
DATAFILE '/disk1/u01/app/oracle/oradata/cdb1/pdbcdb2/users01.dbf' SIZE 250M AUTOEXTEND ON
FILE_NAME_CONVERT=(‘/disk1/u01/app/oracle/oradata/cdb1/pdbseed’,’/disk2/u01/app/oracle/oradata/cdb1/pdbcdb2’);
2). Cloning a PDB From an Existing PDB;
code:
CREATE PLUGGABLE DATABASE PDBCDB2 FROM PDBCDB1
FILE_NAME_CONVERT=( ‘/disk1/u01/app/oracle/oradata/cdb1/pdbcdb1/’, ‘/disk2/u01/app/oracle/oradata/cdb1/pdbcdb2/’);
Both ways it ends up with the same sort of error message:
ORA-65005: missing or invalid file name pattern for file -
/disk1/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_h4mfhqq2_.dbf
Can anyone please point me to the right direction to accomplish this job?
Many thanks in advance.