create pdb from source results in ora-01119 and ora-27040: how to prevent/fix?
I am creating a pdb from a non-cdb source via a dblink:
create pluggable database DB12 FROM NON$CDB@sourcedblink file_name_convert=('BANNOCDB','BANCDB/DB12') keystore identified by "xxxxxxxxxxx" parallel 32 tempfile reuse;
About 6 hours later, I get this error:
ERROR at line 1:
ORA-01119: error in creating database file '/u07/oradata/BANCDB/DB12/temp_BANCDB/DB12_1.dbf'
ORA-27040: file create error, unable to create file
SVR4 Error: 2: No such file or directory
Additional information: 1
The error is correct, the file or directory does not exist. In fact, the entire tree starting with DB12 does not exist when I first start. Why is the create pdb failing to create this directory and file?