breno,
i believe the 'no logging' option only applies to data that is direct loaded into your tables
therefore, you may be able to bypass logging if you used sqlldr or 'create table as select'
good luck,
steve
"Breno A. K. Magnago" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 01/29/2003 09:09 AM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re[2]: undo tablespace |
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).