A Mystery - Create pfile and Quotes
From: Howard Latham <howard.latham_at_gmail.com>
Date: Tue, 9 Nov 2021 13:16:14 +0000
Message-ID: <CAPCNhx1ku9sWkiF5EyvGFN68=NRcR+iZpWh9T+32SQ=mn0m9tw_at_mail.gmail.com>
We have a job that runs every night that creates a pfile from the database for code control purposes.
Date: Tue, 9 Nov 2021 13:16:14 +0000
Message-ID: <CAPCNhx1ku9sWkiF5EyvGFN68=NRcR+iZpWh9T+32SQ=mn0m9tw_at_mail.gmail.com>
We have a job that runs every night that creates a pfile from the database for code control purposes.
execute immediate 'create pfile=''${shadowdir}/init'||sid||'.memory'' from memory';
There is a bit of ‘post-processing’ to mask fluctuating values in the generated file but nothing related to the observation below
Sunday night it generated a new file almost like the previous except a string (all?) quoted values used “ (double-quote) instead of ‘ (single-quote):
So usually single quotes around values but Sunday Double Quotes
Oracle 19.12 RH 7.9.
Not really worried just very puzzled. Is there a Quote separator parameter that can be changed?
--http://www.freelists.org/webpage/oracle-l Received on Tue Nov 09 2021 - 14:16:14 CET