Oracle-23ai-New-Features

I've played with several DEMOs of Oracle 23ai New Features of Free version on my laptop Windows X10 in recent two months (2024.11 - 2024.12).

1. Demo Environments

• Oracle Database 23ai Free (23.6) For Windows X64

• Oracle Database 19c (19.14) For Windows X64

2. Author

Quanwen Zhao

3. Demo Contents

• Tablespace Type Default as Big File on 23 ai - admin_ttdabf.sql
• Big File Tablespace Shrink supported by 23ai - admin_bfts.sql
• SQL*Plus Enhancement on 23 ai - admin_spe.sql
• Read-Only PDB Users supported by 23 ai - admin_ropu.sql
• Rename LOB Segments NOT supported by 19c - admin_rls_no_1914c.sql
• Rename LOB Segments supported by 23ai - admin_rls_23ai_Free.sql
• Unrestricted Direct Loads NOT supported by 19c - admin_udl_no_1914c.sql
• Unrestricted Direct Loads supported by 23ai - admin_udl_23ai_Free.sql
• Schema Privileges new-added on 23ai - sec_sp.sql
• DB_DEVELOPER_ROLE new-added on 23ai - sec_ddr.sql
• Column-Level Auditing new-added on 23ai - sec_cla.sql
• Aliases in GROUP BY clause of SQL supported by 23ai - sql_gba.sql
• Direct Joins For UPDATE And DELETE of SQL supported by 23ai - sql_djfuad.sql
• New Table Value Constructor supported by 23ai (from 23.4) - sql_ntvc.sql

4. Demo Videos

• Tablespace Type Default as Big File on 23 ai - TTDABF
• Big File Tablespace Shrink supported by 23ai - BFTS
• SQL*Plus Enhancement on 23 ai - SPE
• Read-Only PDB Users supported by 23 ai - ROPU
• Rename LOB Segments NOT supported by 19c - RLS-NO-1914c
• Rename LOB Segments supported by 23ai - RLS-23ai-Free
• Unrestricted Direct Loads NOT supported by 19c - UDL-NO-1914c
• Unrestricted Direct Loads supported by 23ai - UDL-23ai-Free
• Schema Privileges new-added on 23ai - SP
• DB_DEVELOPER_ROLE new-added on 23ai - DDR
• Column-Level Auditing new-added on 23ai - CLA
• Aliases in GROUP BY clause of SQL supported by 23ai - GBA
• Direct Joins For UPDATE And DELETE of SQL supported by 23ai - DJFUAD
• New Table Value Constructor supported by 23ai (from 23.4) - NTVC

5. Others

You can also found out the introduction of this demo on main_demo_intro.sql

6. Slides

Here'are two slides about Oracle Database 23ai New Features For DBAs with Admins and SQL.

• For DBAs with Admins - DBAs眼中的Oracle23ai%20管理%20新特性-无背景.pdf
• For DBAs with SQL - DBAs眼中的Oracle23ai%20SQL%20新特性-无背景.pdf