Stephane, I don't understand what you mean when you say you can select on t1 before any commit.
I just tried this on an 8.1.7 database, and there was a signicant reduction in redo. There was only 668 bytes of redo generated vs. 2320 (see below). I think some redo will still be generated as you allocate extents (my tablespace is dictionary managed). Rob Pegram Oracle Certified DBA ---------------------------------------------------- SQL> create table t as select * from dba_users; Table created. SQL> alter table t nologging; Table altered. SQL> delete from t; 15 rows deleted. SQL> commit; Commit complete. SQL> select value from v$mystat, v$statname where v$mystat.statistic# = v$statname.statistic# and v$statname.name = 'redo size' VALUE ---------- 117720 SQL> insert /*+ append */ into t as select * from dba_users; insert /*+ append */ into t as select * from dba_users * ERROR at line 1: ORA-00926: missing VALUES keyword SQL> insert /*+ append */ into t select * from dba_users; 15 rows created. SQL> commit; Commit complete. SQL> select value from v$mystat, v$statname where v$mystat.statistic# = v$statname.statistic# and v$statname.name = 'redo size' VALUE ---------- 118388 SQL> delete from t; 15 rows deleted. SQL> SQL> commit; Commit complete. SQL> select value from v$mystat, v$statname where v$mystat.statistic# = v$statname.statistic# and v$statname.name = 'redo size' VALUE ---------- 123856 SQL> insert into t select * from dba_users; 15 rows created. SQL> commit; Commit complete. SQL> select value from v$mystat, v$statname where v$mystat.statistic# = v$statname.statistic# and v$statname.name = 'redo size' VALUE ---------- 126176 --- paquette stephane <[EMAIL PROTECTED]> wrote: > Hi, > > I'm trying the following insert /*+ append */ into > t1 > as select * from t2; > > t1 is created with nologging attribute. > > The insert is not using the hint at all. > I can select on t1 (before any commit) which I > should > not be able to do if the append hint was used. > > Any ways to get the hing used ? > (Oracle 817/NT) > > TIA > > ===== > Stéphane Paquette > DBA Oracle, consultant entrepôt de données > Oracle DBA, datawarehouse consultant > [EMAIL PROTECTED] > > ___________________________________________________________ > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et > en français ! > Yahoo! Mail : http://fr.mail.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: =?iso-8859-1?q?paquette=20stephane?= > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).