Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Temp tables and redo log/archive mode

Temp tables and redo log/archive mode

From: <miskiewicz2_at_yahoo.com>
Date: 31 Jan 2005 12:09:21 -0800
Message-ID: <1107202161.565728.106010@z14g2000cwz.googlegroups.com>


Hi folks,

during a data import we need to import data into a table to process it there and after processing it we need to delete all data from that table. This works just fine, however this bloats the redo log. When run but the database in archive mode, but we don't need the redo for that action. Is a temp table a solution here, i.e. when I use a temp table for the data import or a buffer will this data creation and deletion of data in that table be still protocolled in the redo log?

Thanks
Tom Received on Mon Jan 31 2005 - 14:09:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US