Not able to hot clone remote pdb with same name [message #684029] |
Thu, 25 March 2021 17:43 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/82920145e40e0c65c671e4d0b8212ab7?s=64&d=mm&r=g) |
juniordbanewbie
Messages: 250 Registered: April 2014
|
Senior Member |
|
|
Dear all,
CREATE PLUGGABLE DATABASE illinois FROM illinois@clone_link
FILE_NAME_CONVERT =
('D:\APP\ORACLE\ORADATA\USA\ILLINOIS\APPSDATA\STATS_0012.DBF','P:\APP\ORACLE\ORADATA\USA\ILLINOIS\APPSDATA\STATS_002.DBF','D:\APP\ORACLE\ORADATA\USA\ILLINOIS\APPSDATA\STATS_001.DBF','P:\APP\ORACLE\ORADATA\USA\ILLINOIS\APPSDATA\STATS_001.DBF');
error
ORA-65005: missing or invalid file name pattern for file -
D:\APP\ORACLE\ORADATA\USA\ILLINOIS\SYSTEM01.DBF
my task is to duplicate the remote pdb but with some files shifting to a new location. it is not using OMF.
many thanks in advance!
|
|
|
|
|
|
|
Re: Not able to hot clone remote pdb with same name [message #684053 is a reply to message #684052] |
Mon, 29 March 2021 12:52 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8931 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
This is beginning to look like trolling: being deliberately stupid, in an attempt to make people angry.
However, I shall assume that it is not deliberate, and try to explain again.
The error message is clear: you need to supply old-to-new mappings for ALL the datafiles that need them. Not just two.
|
|
|