My Oracle Support Banner

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

Last updated on NOVEMBER 21, 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.

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered with an Oracle database product or other training material.  Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

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.