Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Posts
    8

    Question Unanswered: nologging in archive

    The parameter " NOLOGGING " in my tables and indexes not to generate ARCHIVE?

    Thank you

    cesalvador

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    From the Oracle documentation:


    logging_clause
    Purpose

    The logging_clause lets you specify whether creation of a database object will be logged in the redo log file (LOGGING) or not (NOLOGGING).

    This clause also specifies whether subsequent Direct Loader (SQL*Loader) and direct-path INSERT operations against the object are logged (LOGGING) or not logged (NOLOGGING).

    You can specify the logging_clause in the following statements:

    * CREATE TABLE and ALTER TABLE: for logging of the table, one of its partitions, a LOB segment, or the overflow segment of an index-organized table (see CREATE TABLE and ALTER TABLE).
    * CREATE INDEX and ALTER INDEX: for logging of the index or one of its partitions (see CREATE INDEX and ALTER INDEX).
    * CREATE MATERIALIZED VIEW and ALTER MATERIALIZED VIEW: for logging of the materialized view, one of its partitions, or a LOB segment (see CREATE MATERIALIZED VIEW and ALTER MATERIALIZED VIEW).
    * CREATE MATERIALIZED VIEW LOG and ALTER MATERIALIZED VIEW LOG: for logging of the materialized view log or one of its partitions (see CREATE MATERIALIZED VIEW LOG and ALTER MATERIALIZED VIEW LOG.)
    * CREATE TABLESPACE and ALTER TABLESPACE: to set or modify the default logging characteristics for all objects created in the tablespace (see CREATE TABLESPACE and ALTER TABLESPACE.)

    You can also specify LOGGING or NOLOGGING for the following operations:

    * Rebuilding an index (using CREATE INDEX ... REBUILD)
    * Moving a table (using ALTER TABLE ... MOVE)
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  3. #3
    Join Date
    Jan 2003
    Posts
    8

    Wink nologging in archive

    The documentation of Oracle already verified, but he/she would like to know it is generated or non archive with to parameter NOLOGGING.

    <><><><><>


    Originally posted by Ruudboy
    From the Oracle documentation:


    logging_clause
    Purpose

    The logging_clause lets you specify whether creation of a database object will be logged in the redo log file (LOGGING) or not (NOLOGGING).

    This clause also specifies whether subsequent Direct Loader (SQL*Loader) and direct-path INSERT operations against the object are logged (LOGGING) or not logged (NOLOGGING).

    You can specify the logging_clause in the following statements:

    * CREATE TABLE and ALTER TABLE: for logging of the table, one of its partitions, a LOB segment, or the overflow segment of an index-organized table (see CREATE TABLE and ALTER TABLE).
    * CREATE INDEX and ALTER INDEX: for logging of the index or one of its partitions (see CREATE INDEX and ALTER INDEX).
    * CREATE MATERIALIZED VIEW and ALTER MATERIALIZED VIEW: for logging of the materialized view, one of its partitions, or a LOB segment (see CREATE MATERIALIZED VIEW and ALTER MATERIALIZED VIEW).
    * CREATE MATERIALIZED VIEW LOG and ALTER MATERIALIZED VIEW LOG: for logging of the materialized view log or one of its partitions (see CREATE MATERIALIZED VIEW LOG and ALTER MATERIALIZED VIEW LOG.)
    * CREATE TABLESPACE and ALTER TABLESPACE: to set or modify the default logging characteristics for all objects created in the tablespace (see CREATE TABLESPACE and ALTER TABLESPACE.)

    You can also specify LOGGING or NOLOGGING for the following operations:

    * Rebuilding an index (using CREATE INDEX ... REBUILD)
    * Moving a table (using ALTER TABLE ... MOVE)

  4. #4
    Join Date
    Jan 2003
    Posts
    8

    Wink

    The documentation of Oracle already verified, but I would like to know it is generated or non archive with to parameter NOLOGGING.

  5. #5
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Smile

    To disable redo logs/archived logs creation, it's not enough to alter your tables/indexes with NOLOGGING clause.

    It also depends on the DDL/DML operations performed. Not all such commands will stop generating redo logs, which then have to be archived if in ARCHIVEDLOG mode. Please, read This information (third post) to clarify this subject once forever.


    Hope that helps,

    clio_usa - OCP - DBA


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •