Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
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;
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
2). Cloning a PDB From an Existing PDB;
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 -
Can anyone please point me to the right direction to accomplish this job?
Many thanks in advance.