Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Dbms_refresh and archived logs
Complete refresh uses hint --+ append
So if the MVW is defined as nologging, there should not be any redo except
for index rebuild.
Also indexes could be dropped and rebuilt after the refresh.
Only if it's complete refresh.
Regards,
Waleed
-----Original Message-----
From: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca]
Sent: Monday, March 01, 2004 10:55 AM
To: 'oracle-l_at_freelists.org'
Subject: Dbms_refresh and archived logs
Is there a way to prevent dbms_refresh from generating redo log entries? One job generates 170+ archived logs every morning.
The tablespace, tables are all set to nologging but makes no difference.
I logged a TAR but so far the response I got was: how about setting your database in noarchivelog mode. LOL
Patrice.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
![]() |
![]() |