Re: help - nologging

From: Gilles PARC <gparc_at_online.fr>
Date: Mon, 22 May 2000 20:57:11 +0200
Message-Id: <10505.106284@fatcity.com>

Hi Salu,

At 08:15 22/05/2000 -0800, you 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.
>

Look at the unrecoverable parameter in sql*loader documentation

HTH Regards

Gilles Parc
Email : gparc_at_mail.dotcom.fr Received on Mon May 22 2000 - 13:57:11 CDT