think CAREFULLY about this as it invalidates your recovery procedures. Nologging means there is nothing in the redo logs to be applied. and your backup is invalid.
Other than that, I suggest you do some research in the Oracle docs. A VERY brief check (search on nologging) brought me this information: Direct-path INSERT is subject to a number of restrictions. If any of these restrictions is violated, then Oracle executes conventional INSERT serially without returning any message (unless otherwise noted): * You can have multiple direct-path INSERT statements in a single transaction, with or without other DML statements. However, after one DML statement alters a particular table, partition, or index, no other DML statement in the transaction can access that table, partition, or index. * Queries that access the same table, partition, or index are allowed before the direct-path INSERT statement, but not after it. * If any serial or parallel statement attempts to access a table that has already been modified by a direct-path INSERT in the same transaction, then Oracle returns an error and rejects the statement. * The ROW_LOCKING initialization parameter cannot be set to INTENT. * The target table cannot be index organized or clustered. * The target table cannot contain object type or LOB columns. * The target table cannot have any triggers or referential integrity constraints defined on it. * The target table cannot be replicated. * A transaction containing a direct-path INSERT statement cannot be or become distributed. --- "Breno A. K. Magnago" <[EMAIL PROTECTED]> wrote: > Mike, > > I asked it because I have a problem. > Any insert data in UNDO tablespace generate insert in REDO Files. Is > is correct ? > > When I execute a high procedure, many inserts in UNDO tablespace > ocurres, so many inserts in REDO´s are genereate. > I want to avoid this REDO´s generation. > My tables and indexes are in NOLOGGING, but I high value of > REDO are generate (100 MB each 20 minutes). It is desnecessary. > > Oracle 9i / NT > > -- > Breno A. K. Magnago > mailto:[EMAIL PROTECTED] > Mercantil de Alimentos Soares > > Wednesday, January 29, 2003, 10:29:15 AM, you wrote: > > HMNI> Breno, > HMNI> There's no way to do this because it's the central pillar of > Oracle's read > HMNI> consistency mechanism. > HMNI> It's possible to minimise or suppress redo but undo is out of > your control. > > HMNI> regards, > HMNI> Mike Hately > > HMNI> -----Original Message----- > HMNI> Sent: 29 January 2003 11:39 > HMNI> To: Multiple recipients of list ORACLE-L > > > HMNI> I have a high procedure (many INSERT's and UPDATE´s). > HMNI> This procedure generate insert's in UNDO TableSpace for > rollback. > HMNI> I want to know if exists any way for don´t generate insert´s in > UNDO > HMNI> Tablespace. > > HMNI> Oracle 9i / NT > > HMNI> Thanks. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Breno A. K. Magnago > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).