My Oracle Support Banner

FAQ: Read only Partitions and Subpartitions in 12.2 (Doc ID 2218165.1)

Last updated on JANUARY 15, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.
Read Only Partitions and Subpartitions is a new feature in Oracle 12.2

Purpose

The purpose of this note is to explain how to implement Read Only Partitions and Subpartitions.

Questions and Answers

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

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


In this Document
Purpose
Questions and Answers
 1. How to create a partitioned table with partitions set to read only by default:
 2. How to create a partitioned table with a partition that is set to read only by default,  so that all the subpartitions are read only by default;
 3. How to create a partitioned with some partitions read only and some subpartitions read only:
 4. How to alter a partitioned table with partitions set to read only by default:
 5: How to alter a partitioned table with partitions set to read only by default:
 6. How to check to see which partitions and/or subpartitions are read only :

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