Showing posts with label Partition. Show all posts
Showing posts with label Partition. Show all posts

Thursday, July 9, 2020

Adding Partition To Existing Table In Oracle

How do I alter my existing table to create a range partition in Oracle

Creating partition is on a table is very important when you want to see performance improvement especially on DATE columns.
In this post, We will learn how to alter existing table with partition.

How to Create User and Grants in Oracle

What is Partition in Oracle:

Oracle Partitioning allows tables and indexes to be partitioned into smaller, more manageable units, providing database administrators with the ability to pursue a "divide and conquer" approach to data management. ... That table could be range- partitioned so that each partition contains one day of data.

Adding Partition To Existing Table In Oracle