Re: Extended Data types

Interesting about functions returning varchar2. We have some of those and that will be a fun test.
I am on 12.2 and I did try to enabled extended data types and got an error with some XDB tables. Oracle support said the table XDB_PRIN was supposed to have been dropped during 12.2 upgrade but apparently not in my case.

On Wed, Oct 30, 2019 at 9:00 AM Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:

> If it's 12.1 there's one catch (described here:
> https://jonathanlewis.wordpress.com/2016/02/11/quiz-night-29/ ) if you
> have code that does a CTAS that includes derived columns without casting
> them to explicit sizes.
>
> There are also some potential performance threats due to array processing
> collapsting to single row if the row definitions are too long (
> https://jonathanlewis.wordpress.com/2014/12/23/just-in-case/ )
>
> Inevitably Richard Foote has some comments about the problems of tyring to
> index the columns; and functions returning varchar2 now return
> varchar2(32767) so you may find some FBI suddenly become "interestingly
> different".
>
> Some things may have changed by 12.1, though - I havent' set up a 12.2
> with extended character types
>
> Regards
> Jonathan Lewis
>
> ________________________________________
> From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> behalf of Jeff Chirco <backseatdba_at_gmail.com>
> Sent: 29 October 2019 16:05
> To: oracle-l-freelist
> Subject: Extended Data types
>
> Hi all,
> Has anyone enabled extended data types in 12c to get varchar2(32767)
> support for the tables? We are looking to do this but wondering if anyone
> has experienced any issues with it cause I know there is no going back once
> you do.
>
> Thanks,
> Jeff
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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