Read Only Partitions 12.2

In 12.2 a partition or sub-partition can be marked as READ ONLY at the time of creation (CREATE TABLE) or later (ALTER TABLE).

It must specify key word READ ONLY. READ WRITE is the default.

 

Example 1: (yxy is partitioned table)

SQL>ALTER TABLE yxy READ ONLY;
All current and future created partitions will be read only.

Example 2:

SQL>ALTER TABLE yxy MODIFY PARTITION yxy_p4 READ ONLY;
All partitions except yxy_p4 are read only.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.