New Features 23c: Asynchronous Transactions

As new features within Oracle Database 23c, we can create a column that support multiple modification simultaneous, conditions;

1. Deferred_segment_creation should be false
2. Table contains column with primary Key.
3. Use the option RESERVABLE.
4. Reservable column update statement only supports + or – operations on a reservable column.

Example: Create a Table with Column RESERVABLE Options

First Session:

Second Session:

Error: Cannot drop table with PRESERVE Column, so we need to remove this PRESERVE condition

Enjoy this new features with 23c.