First introduced in 12.2 . It basically determines how the string comparison takes place. In order to use the feature, extended data types should be enabled, I work on an great autonomous TP instance and it is already enabled: The feature is supported at different levels: column table schema session database statement In this post, […]Read more "Column Level Collation Example"
Database: Oracle Database 19c Enterprise Edition Release 220.127.116.11.0 – Production Version 18.104.22.168.0 I write this post in order to follow step by step how a bigfile tablespace is created and managed in 19c. The main purpose is to find a way to estimate the space benefits of defragmenting the tablespace. I will use two methods: […]Read more "Estimate Defragmentaton Benefits for a Bigfile Tablespace"