Re: 18c Service Names

Morning Jack,

On 06/07/2020 22:52, Jack Applewhite wrote:
> Turns out I misused the Service_Name_Convert part of creating the PDBs
> from the .pdb files. It's all better now.
>
> However, a "gotcha" of using it is that it will replace the leading part
> of *any* target Service_Name matching the new Service_Name, as in:
>    Service_Name_Convert('MYDB','HISDB')
> ...will change the following...
> MYDB          to HISDB          <<< Expected
> MYDB10      to HISDB10      <<< NOT Expected
> MYDBTEST to HISDBTEST <<< NOT Expected

I'm pretty sure that this is the case with all the various xxxx_convert parameters. I fell into that trap on a previous contract and made a note. Back then, it was just DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT, but I got bitten!

Cheers,
Norm.

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG

Company Number: 05132767
--
http://www.freelists.org/webpage/oracle-l