Re: Disabling Redo Logs

Hi,

yes you can turn off the online redo logs using a 'underscore' parameter, but do not do that! As you probably know Oracle dose not want anybody to use any underscore parameter without them telling them (and that's why the v$parameter view does not show them).

The direct path option in SQL*Loader (and exp/imp in 7.3) bypasses logging (specify direct=yes). If you want to split your loads in severeal streams you could do that by specifying parallell=yes. You do not have to split your data into several tables, you can load multistream via direct path into one single table. If one of the loads fail you even can rerun it without having to run the other loads.

Rgds
Steinar  

Mark Rosenbaum (mjr_at_netcom.com) wrote:
: In article <331d2033.2569582_at_news.emi.net>, Vikram Goel <vgoel_at_emi.net> wrote:
: >Ugo Ribecai<sysdata.pisa_at_iol.it> (Ugo Ribecai) wrote:
: >
: >>It's possible ???
: >>
: >>Thanks
: >
: >Ugo,
: >
: >This is not possible. Redologs are a requirement of Oracle.
: >
: This is correct but, you can turn logging off in some situations.
: If you are creating a table from a select in O7.2 or later you can
: use the unrecoverable options which turns off logging. Same with
: indexes I believe. Also if you are loading from flat files into
: a table use direct=yes to avoide logging.
 

: These approaches require that you create/load as a single unit since
: there is no logging. The safest way to do this is to create a seperate
: table for each load and then create a view over them (see partitioned
: views) in O7.3
 

: Hope this helps

: Mark Rosenbaum Otey-Rosenbaum & Frazier, Inc.
: mjr_at_netcom.com Consultants in High Performance and
: (303) 727-7956 Scalable Computing and Applications
: POB 1397 ftp://ftp.netcom.com/pub/mj/mjr/resume/
: Boulder CO 80306
  Received on Fri Mar 14 1997 - 00:00:00 CST