Thursday , June 8 2023

How To Convert A Non-Partitioned Table To Partitioned Table Online in Oracle Using DBMS_REDEFINITION

With the DBMS_REDEFINITION package in the Oracle database, it is possible to modify the structure of the tables online. We can convert a non-partitioned table online into a partitioned structure with DBMS_REDEFINITION. The process steps will be as follows.

The following example specifies the steps required to convert a non-partitioned DEMO1 table to a partitioned DEMO table.

Primary key must be present in the table.

Create a non-partitioned table

Let’s create the table we want to partition with primary key.

Create a partitioned table

Check if online redefinition is possible for the table

Start the necessary process

Synchronize data in tables

Complete the Process

Check Table is Partitioned


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *