Table Logging And Nologging

Onur ARDAHANLI

5 months ago

In today’s article, we will be learning how to Logging and Nologging the Table in the Oracle database.

The logging_clause lets you specify whether certain DML operations will be logged in the redo log file (LOGGING) or not (NOLOGGING).

We can log while creating the table or later.

Logging / nologging while creating the table;

SQL> create table DENEME(
2  ID number(3),
3  NAME varchar2(20))
4  nologging
5  tablespace DENEME;
	
Table created.

SQL> create table DENEME(

2 ID number(3),

3 NAME varchar2(20))

4 nologging

5 tablespace DENEME;

Table created.

Logging/nologging the table afterwards.

SQL> alter table DENEME nologging;
	
Table altered

SQL> alter table DENEME nologging;

Table altered