partitioned table

Database Administration & Monitoring, Database management, Development & Performance, SQL Server

Customer case study – SQL Server table partitioning

07.02.2025 by Amine Haloui

A client submitted the following issues : Their database hosts multiple tables, including one table of approximately 1 TB, consisting of several billion rows. This table is continuously fed by various data sources. Additionally, it is also used to(…)

Database Administration & Monitoring, Database management, Development & Performance, Oracle

Oracle Exchange Partition

21.10.2022 by Oracle Team

The Oracle Exchange Partition is a method allowing to : exchange the data segments from a non partitioned table to a partitioned table exchange the data segments from a partitioned table to a non partitioned table. This method(…)

Database Administration & Monitoring

Oracle 12cR2 : Partitioning improvements – online conversion of a non-partitioned table to a partitioned table

06.01.2017 by Joël Cattin

It’s time to a new blog about partitioning improvement in 12cR2. After auto-list partitioning and multi-column list partitioning & read-only partitions, I’ll demonstrate how we can easily convert a non-partitioned table to a partitioned(…)