Re: Extended Data types
Date: Wed, 30 Oct 2019 15:59:16 +0000
Message-ID: <CWXP265MB175073FE9C2818C1D0AF94FAA5600_at_CWXP265MB1750.GBRP265.PROD.OUTLOOK.COM>
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
Hi all,
Thanks,
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
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.
Jeff
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 30 2019 - 16:59:16 CET