My Oracle Support Banner

Examples about Insert into Range Partitioned Tables. (Doc ID 165303.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition
Information in this document applies to any platform.


Purpose

Presentation of the algorithm's Range Partitioning  used to determine in which partition a 
new row should be inserted when using a single or multi-column partition key.
Explain the mechanism of updatable partition keys introduced with the 8i version.

Scope

The article is designed for DBA's who want to acquire quickly some knowledges
about how insert datas on RANGE partitions.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.