Re: help - nologging

From: Gaja Krishna Vaidyanatha <gajav_at_yahoo.com>
Date: Mon, 22 May 2000 11:10:14 -0700 (PDT)
Message-Id: <10505.106267@fatcity.com>

Salu,

The "alter table nologging;" is not an alternative to the "alter database noachivelog;", not by a long shot. The NOLOGGING feature in table is relevant only for certain operations like direct-load comparable operations such as using the /*+ APPEND */ hint and certain partition management features. The NOLOGGING is also relevant for index creation and/or rebuilding.  NOLOGGING is pretty much the UNRECOVERABLE feature in Oracle7 with a few more bells and whistles added to it for the Parallel DML and Partitioning features.

So the generation of redo logs for your load operation is normal. You could have tried. You might want to dig into the manuals for more detail.

Cheers,

Gaja.

• salu Ullah <salu_ullah_at_hotmail.com> wrote:
  > Hello,
  >
  > I altered a table with nologging option & loaded 10 mil rows.
  > I then checked
  > the archiving folder & found that it builds a bundle of arch
  > file & took all
  > the space.
  > According to my understanding if i want to stop archiving
  > while loading a
  > data, the other alternate to 'alter database noarchivelog' is
  > to alter the
  > table to nologgoing. Cant shutdown the database.
  > Please correct me if iam wrong.
  > I have a table in which i have to load 30 mill rows. Using
  > loader fill up my
  > archiving space after 5 mil inserts.
  > Thanks in advance.
  >
  > Salu
  >
  > _________________________________________________________________
  

  ---

Gaja Krishna Vaidyanatha   | 3460 West Bayshore Road,
Manager - Integration      | Palo Alto, CA 94303
& Consulting Services      | gaja_at_brio.com
Global Alliances           | (650)-565-4442
Brio Technology            | www.brio.com 

"Opinions and views expressed are my own and not of Brio Technology"

---

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. Received on Mon May 22 2000 - 13:10:14 CDT