OraFAQ Forum: Performance Tuning » Change from LOGGING to NOLOGGING for a table

Home » RDBMS Server » Performance Tuning » Change from LOGGING to NOLOGGING for a table (Oracle 11G R2)

Fri, 28 November 2014 04:27

OlafCologne
Messages: 11
Registered: September 2008
Location: Cologne

Junior Member

I want to set a large table (but not very important data) during operation on NOLOGGING. Can I do this easily?

Thanks!

Fri, 28 November 2014 08:20

John Watson
Messages: 8501
Registered: January 2010
Location: Global Village

Senior Member

orclz>
orclz> alter table emp nologging;

Table altered.

orclz> alter table emp logging;

Table altered.

orclz>

Seem pretty easy to me Smile

Previous Topic:	Please help me to understand why the query works longer of server_A than on server_B
Next Topic:	SQL tuning

Goto Forum:

]

Current Time: Fri Mar 05 02:03:16 CST 2021