Nologging on INSERT

Hi,

I have a INSERT, but I don't want it to be logged as it creates a big archivelogs. How do I make INSERT NOLOGGING. Is it possible since I can't find that option in the docs. (I have Oracle8.1.5 standard edition).

Thanx!

you can only use nologging option if you do direct inserts

first alter the table to nologging attribute
then

insert /*+ append */ into xxxx
select * from yyyy;

direct insert is insert.... select....
there is no way you can avoid logging in a normal insertion

Thanx! it is clear to me now