Read-Only partitions are of benefits

1.When you are working in Data-Warehouse environment there must be many partitions which are not updated frequently you can add those partitions to read-only state and then add those partitions to read-only tablespace. These read-only tablespace can help you take your RMAN backup faster as read-only tablespace can be avoided to be backed up in incremental backups.

2.By putting partitions to read-only state you can perform maintenance activity.

3.You can put partition or subpartition in read only state.

4.You can manage table partitions effectively as per there use using this option.

Now , how to create read-only partitions and check if they are in read only state or not.

1.Create table with read-only partitions

2.Let’s check in USER_TAB_PARTITIONS view if partitions are created in read only state

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

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