Hi,
I'm in ORACLE 10gR2/Redhat4
I need to insert in a table more than 1000000 rows with NOLOGGING.
For that I do:
alter table TRACES_00_HIST NOLOGGING;
SQL> ed
écrit file afiedt.buf
1 INSERT /*+ APPEND */ INTO TRACES_00_HIST
2 (select traces_00_seq.nextval AS ID,TRACE_DATE,TIMESTAMP AS TSTAMP,TYPE_OF_ACTION,
3 from TRACES_OLD
4 where OPCO_ID in (0,-1)
5* and TO_CHAR(CREATED_TIME,'yyyymmdd') <= TO_CHAR(sysdate -366,'yyyymmdd'))
SQL> /
1440592 ligne(s) créée(s).
Statistiques
- -------------------------------------------------------- -
42337 recursive calls
256523 db block gets
1507334 consistent gets
1482469 physical reads
*231394900 redo size*
535 bytes sent via SQL*Net to client
830 bytes received via SQL*Net from client
4 SQL*Net roundtrips to/from client
9 sorts (memory)
0 sorts (disk)
1440592 rows processed
I'm doing some thing wrong? why my insert is genrating redo?
I try this Link:
665145 and it's working fine but not with my query!!
Please help