Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Nologging

Re: Nologging

From: Jim Walski <jwalski3_at_classicplan.com>
Date: Wed, 28 Mar 2001 18:27:34 -0800
Message-ID: <F001.002DAE4F.20010328180057@fatcity.com>

Yes you can issue the alter table nologging but it will only be relevant for certain operations not all UPDATE, DELETE, conventional path INSERT statements.

Jim

Reference the following I found on metalink:

Doc ID: Note:1038660.6
Type: PROBLEM
Status: PUBLISHED
 Content Type: TEXT/PLAIN
Creation Date: 21-NOV-1997
Last Revision Date: 02-MAY-2000
Language: USAENG

PURPOSE
This article gives further information about the options UNRECOVERABLE in Oracle7 and NOLOGGING in Oracle8.

SCOPE & APPLICATION
For users requiring further information about these options.

The options UNRECOVERABLE in Oracle7 and NOLOGGING in Oracle8 can be used when creating a table as select. They will send the actual create statement to the redo logs (this information is needed in the data dictionary). All rows loaded into the table during the create are not sent to the redo logs.

With UNRECOVERABLE in Oracle7 any subsequent Data Manipulation Language (DML)
command on the table WILL be sent to the redo logs.

The UNRECOVERABLE option can be used in early versions of Oracle8 but will eventually be replaced by the NOLOGGING option.

With NOLOGGING in Oracle8, although you can set the NOLOGGING attribute for a table, partition, index, or tablespace, NOLOGGING mode does not apply to every operation performed on the schema object for which you set the NOLOGGING attribute.

Only the following operations can make use of the NOLOGGING option:

    alter table...move partition
    alter table...split partition
    alter index...split partition
    alter index...rebuild
    alter index...rebuild partition

    create table...as select
    create index
    direct load with SQL*Loader
    direct load INSERT

All of these SQL statements can be parallelized. They can execute in LOGGING or NOLOGGING mode for both serial and parallel execution.

Other SQL statements (such as UPDATE, DELETE, conventional path INSERT, and various DDL statements not listed above) are unaffected by the NOLOGGING attribute of the schema object.

-----Original Message-----
To: ORACLE-L_at_fatcity.com <ORACLE-L_at_fatcity.com>; Jwalski3 <jwalski3_at_classicplan.com>
Date: Wednesday, March 28, 2001 5:25 PM

>
>that has nothing to do with the question. But anyway, try ALTER TABLE
>NOLOGGING instead.
>
>oli
>
>
>jwalski3_at_classicplan.com wrote
>> Alter database noarchivelog;
>>
>> will change the entire database.
>>
>> see the following for detailed information:
>>
>> http://technet.oracle.com/docs/products/oracle8i/doc_index.htm
>>
>> HTH, Jim
>>
>> -----Original Message-----
>> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>> Date: Wednesday, March 28, 2001 4:37 PM
>>
>> >I know it is possible when creating a table to specify no logging
>> >so that it doesn't generate redo logs. Is it possible, AFTER
>> >the table has already been created, to change it to nologging?
>> > Also this is a dev database that we don't care about doing any
>> >type of recovery and just want to do some quick loads -- is it
>> >possible to change the entire database to nologging?
>> >This is on Oracle 8.0.5.
>> >
>> >-----
>> >Sent using MailStart.com ( http://MailStart.Com/welcome.html )
>> >The FREE way to access your mailbox via any web browser, anywhere!
>> >
>> >--
>> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> >--
>> >Author:
>> > INET: cemail_at_sprintmail.com
>> >
>> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> >San Diego, California -- Public Internet access / Mailing Lists
>> >--------------------------------------------------------------------
>> >To REMOVE yourself from this mailing list, send an E-Mail message
>> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> >the message BODY, include a line containing: UNSUB ORACLE-L
>> >(or the name of mailing list you want to be removed from). You may
>> >also send the HELP command for other information (like subscribing).
>
>--
>Oliver Artelt
>Oracle Certified DBA
>
>cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
>telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
>email: info@cubeoffice.de # web: http://www.cubeoffice.de

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jim Walski
  INET: jwalski3_at_classicplan.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Mar 28 2001 - 20:27:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US