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
Messages: 9
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?

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: 7304
Registered: January 2010
Location: Global Village
Senior Member
orclz> alter table emp nologging;

Table altered.

orclz> alter table emp logging;

Table altered.


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: Sat Mar 17 06:18:01 CDT 2018

Total time taken to generate the page: 0.05596 seconds