As new features within Oracle Database 23c, we can create a column that support multiple modification simultaneous, conditions;
- Deferred_segment_creation should be false
- Table contains column with primary Key.
- Use the option RESERVABLE.
- Reservable column update statement only supports + or – operations on a reservable column.
Example: Create a Table with Column RESERVABLE Options
Error: Cannot drop table with PRESERVE Column, so we need to remove this PRESERVE condition
Enjoy this new features with 23c.