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

Home -> Community -> Mailing Lists -> Oracle-L -> help - nologging

help - nologging

From: salu Ullah <salu_ullah_at_hotmail.com>
Date: Mon, 22 May 2000 15:07:55 GMT
Message-Id: <10505.106233@fatcity.com> 





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





Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
Received on Mon May 22 2000 - 10:07:55 CDT












Original text of this message













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