How to create a staging table in Oracle 23c

Oracle database 23c introduces a new feature of staging tables to create a table in the Oracle database. The staging table is used in the ETL (extract transfer load) process for applying and modifying the data during transfer to the permanent table.

Create a staging table syntax

create table stagingtable (
  id    number,
  name  varchar2(100),
)
for staging;

Check if the table is Staging or permanent

select table_name,staging from user_tables;

Alter the existing normal table into a staging table

--- Convert normal table to Staging table
alter table normaltable for staging;

--Convert staging table back to normat table
alter table normaltable not for staging;

Note: Staging tables should be used only for interim results and not for permanent storage.