turn off archivelog for one table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: turn off archivelog for one table

  1. #1
    Join Date
    Sep 2002
    Posts
    5

    turn off archivelog for one table

    Hi,

    Our Oracle9i database is currently in archivelog mode.
    Is it possible to turn off the archive mode for a table ??

    Thanks,
    Kris

  2. #2
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    alter table table_name nologging;

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    The general answer for this question is:

    No, you can't turn off the archive mode for a particular table. But in some cases and for very few types of DML operations you can reduce the amount of generated redos by using NOLOGGING option as sugested by fraze.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by fraze
    alter table table_name nologging;
    This will be valid for few operation on the table only: DML for example only above the HWM (append hint, etc).
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  5. #5
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    These setting could be overwrite by

    ALTER DATABASE FORCE LOGGING;
    or
    ALTER TABLESPACE FORCE LOGGING

    Make sure it's not there.

Posting Permissions

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



Click Here to Expand Forum to Full Width