What is logging_clause On Oracle(LOGGING or NOLOGGING)

 

With the logging_clause parameter, we can specify whether the database objects are to be logged in the redo log when they are created, using LOGGING or NOLOGGING.

We can use it for the following operations.

 

You can find Sample Usage below.

All objects that will be created in the following tablespace will default to the LOGGING structure.

In other words, the operations to be performed on these objects will be logged in the redo log.

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 *