Re: set max_string_size to extended at PDB level

THank you.

I just wanted to let you know that it looks like it is working fine, I was able to perform the change to a PDB only.

_at_Clay I would be curious to see the presentation you mention and see why you think this can be problematic.

În lun., 12 dec. 2022 la 17:10, Clay Jackson <dmarc-noreply_at_freelists.org> a scris:

> I have a presentation titled “Oracle Extended Strings, Just Don’t”….
> Send me a PM and I’ll send you a copy.
>
>
>
> While prepping this, I did test a CDB/Single PDB combination, did the CDB
> and then the PDB; then restored and did just the PDB. It APPEARED to work
> (simple insert/update/delete on a single table); but, as they say, “Your
> mileage may vary”. See the section in my paper on defensive
> programming. I certainly would NOT recommend operating in a “split” mode.
>
>
>
> IMHO, one of the biggest issues is that there’s no going back. So, if
> you make the change, something breaks and you want/have to “switch back”,
> you’ll need to build a new database and then try to get the data copied
> back.
>
>
>
> Test, test, test!
>
>
>
> Good luck!
>
>
>
> (Did I say test, test, test)?
>
>
>
> Clay Jackson
>
>
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Laurentiu Oprea
> *Sent:* Monday, December 12, 2022 5:11 AM
> *To:* ORACLE-L (oracle-l_at_freelists.org) <oracle-l_at_freelists.org>
> *Subject:* set max_string_size to extended at PDB level
>
>
>
> *CAUTION:* This email originated from outside of the organization. Do not
> follow guidance, click links, or open attachments unless you recognize the
> sender and know the content is safe.
>
>
>
> Hello everyone,
>
>
>
> Does anyone know if max_string_size can be set to extended at PDB level
> only?
>
>
>
> Assuming I have a container with 10 PDBs I would like to set it to a
> single PDB. Or do I mandatory need to change to the container first then
> all PDBs (including seed) ?
>
>
>
> THanks.
>

--
http://www.freelists.org/webpage/oracle-l