--example for non-OMF database, creating a PDB from scratch
CREATE PLUGGABLE DATABASE testpdb2
ADMIN USER DRADMIN IDENTIFIED BY password
ROLES=(DBA)
DEFAULT TABLESPACE users
DATAFILE '/u01/app/oracle/oradata/CDB1/testpdb2/sales01.dbf'
SIZE 250M AUTOEXTEND ON
PATH_PREFIX = '/u01/app/oracle/oradata/CDB1/testpdb2/'
FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/CDB1/datafile/',
'/u01/app/oracle/oradata/CDB1/testpdb2');
--example for non-OMF database, cloning a PDB
CREATE PLUGGABLE DATABASE testpdb3 from testpdb1
FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/CDB1/testpdb1/',
'/u01/app/oracle/oradata/CDB1/testpdb3')
PATH_PREFIX = '/u01/app/oracle/oradata/CDB1/testpdb3/';