Baanboard.com

Go Back   Baanboard.com > Common DBA Misconceptions

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
36%
Installation Wizard into new VRC
36%
Manual into existing VRC
7%
Manual into new VRC
22%
Total votes: 45

Baanboard at LinkedIn


Reference Content

Book Navigation

 
Redo & Rollback: No logging turns off redo logging
By patvdv at 23 Feb 2008 - 23:25

Many people believe that by setting a segment to NOLOGGING mode, no redo will be generated for DML performed against that segment. In fact, only a limited number of operations can be performed NOLOGGING. According to the Oracle 8i Concepts Guide, only the following operations may take advantage of the NOLOGGING feature:

 

  • direct load (SQL*Loader)
  • direct-load INSERT
  • CREATE TABLE ... AS SELECT
  • CREATE INDEX
  • ALTER TABLE ... MOVE PARTITION
  • ALTER TABLE ... SPLIT PARTITION
  • ALTER INDEX ... SPLIT PARTITION
  • ALTER INDEX ... REBUILD
  • ALTER INDEX ... REBUILD PARTITION
  • INSERT, UPDATE, and DELETE on LOBs in NOCACHE NOLOGGING mode stored out of line
0
No votes yet


All times are GMT +2. The time now is 19:10.


©2001-2017 - Baanboard.com - Baanforums.com