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.

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply