Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Temp tables and redo log/archive mode
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