Home » RDBMS Server » Performance Tuning » Change from LOGGING to NOLOGGING for a table (Oracle 11G R2)
icon5.gif  Change from LOGGING to NOLOGGING for a table [message #628760] Fri, 28 November 2014 04:27 Go to next message
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!
Re: Change from LOGGING to NOLOGGING for a table [message #628791 is a reply to message #628760] Fri, 28 November 2014 08:20 Go to previous message
John Watson
Messages: 7669
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: Sun Nov 18 17:38:47 CST 2018