Read Only Tables in Oracle

What is Read Only Tables in Oracle?

It is possible to use read only tables in Oracle databases starting from 11.1. You can not update read only tables. A table cannot be created as read only, but can be converted to read only with the alter table command.

It is not possible to add columns to Read Only tables in 11gR1, 11gR2 and 12c versions. But in the 18c version and later versions, a new column can be added to the read-only tables.

How do I make a table read only in Oracle?

You can convert a table to read only as follows.

DML operations to a read-only table will result the ORA-12081 error.

You can use the following command to make a “read only” table “read write” again.

How to check if a table is read only oracle

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *