Hi,
I've done some 12c database tests without probs (creating cdb, pdb, converting single instance to pdb...).
However, when doing a real database conversion to PDB, I've encountered the following issue: If the original database has no datafile prefix (since it uses OFA, datafiles paths are /u02/..., /u03/..., /u04/...,), what should I put on FILE_NAME_CONVERT clause?
I'm going to use a path prefix for the new PDB, so it should be something like:
CREATE PLUGGABLE DATABASE scista USING '/tmp/example.xml'
COPY
FILE_NAME_CONVERT = ('???','???')
PATH_PREFIX = '/ora_pdb/scista';
Any ideas?
UPDATE: I found out that FILE_NAME_CONVERT accepts multiple path pairs, so fixed it by using FILE_NAME_CONVERT = ('/u02/', '/ora_pdb/scista/u02','/u03/', '/ora_pdb/scista/u03','/u04/', '/ora_pdb/scista/u04','/u05/', '/ora_pdb/scista/u05','/u06/', '/ora_pdb/scista/u06')
Thanks