Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Disabling Redo Logs
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 Thu Mar 06 1997 - 00:00:00 CST