The NOLOGGING clause specifies that subsequent direct loads using SQL-Loader and direct load INSERT operations are not logged. Note! DML statements (UPDATE, DELETE, and conventional path insert) are unaffected by the NOLOGGING attribute of the table and generate redo. …
May 26, 2018 Direct-Path INSERT and NOLOGGING with Oracle 12.2 | Data Feb 20, 2018 alter tablespace nologging – Talip Hakan Ozturk's ORACLE BLOG SQL> create table talip_nologging nologging as select * from dba_tables; Table created. Elapsed: 00:00:00.60. And there is an important point. If you delete a row from NOLOGGING table then you can rollback. Baceause of it is not depended on LOGGING/NOLOGGING. It is depended on UNDO segments. Let’s do a simple test.
Sep 13, 2006
NOLOGGING affect the recoverability and before going into how to limit the redo generation it is important to clear the misunderstanding that NOLOGGING is the way out of redo generation, this are some points regarding it: Alter index . rebuild nologging Solutions | Experts What is the effect of the nologging keywork? I was under the impression that using nologging while rebuilding will stop the creation of archived logs. But it seems that archive logs are still being generated. When an index is rebuild, a new index is created and then the original ones is dropped. Nologging | Oracle Scratchpad
Sep 13, 2006
Consider NOARCHIVELOG: Take a full backup first and bounce the database into NOLOGGING mode for the delete and bounce it again after, into ARCHIVELOG mode. Use CTAS: Another option you can try would be to create a new table using CTAS where the select statement filters out the rows that you want to delete. Then do a rename of the original How to Enable/Disable ARCHIVELOG Mode in Oracle 11g/12c May 26, 2018 Direct-Path INSERT and NOLOGGING with Oracle 12.2 | Data Feb 20, 2018 alter tablespace nologging – Talip Hakan Ozturk's ORACLE BLOG SQL> create table talip_nologging nologging as select * from dba_tables; Table created. Elapsed: 00:00:00.60. And there is an important point. If you delete a row from NOLOGGING table then you can rollback. Baceause of it is not depended on LOGGING/NOLOGGING. It is depended on UNDO segments. Let’s do a simple test.