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" <breno_at_mercantilsoares.com.br> 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:breno_at_mercantilsoares.com.br
> 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: breno_at_mercantilsoares.com.br
>
> 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: ListGuru_at_fatcity.com (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: wisernet100_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Wed Jan 29 2003 - 09:13:47 CST