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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Imports and Redo logs

RE: Imports and Redo logs

From: Glenn Travis <Glenn.Travis_at_wcom.com>
Date: Wed, 16 Aug 2000 14:01:48 -0400
Message-Id: <10591.114749@fatcity.com>


can you set the temp tables to nologging?

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Steven
> Monaghan
> Sent: Wednesday, August 16, 2000 10:46 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Imports and Redo logs
>
>
> I can't find the answer to this question in the Oracle documentation, so I
> thought maybe this list could help.
>
> We are working on a load process that currently creates about
> 6Gig of redo.
> The process loads flat files into temp tables and then processes
> them into a
> schema. I am suggesting the work be done on another instance which is not
> in archive mode, and the results be EXP/IMP to production.
>
> How are imports written to the redo logs? Would the result of the import
> write about the same amount of data as straight insert statements? My gut
> tells me no, but and direction as to the answer would be appreciated.
>
> Steve Monaghan
> Oracle DBA
> MSC Industrial Direct Co., Inc.
> Melville, NY
> MonaghaS_at_mscdirect.com
>
> --
> Author: Steven Monaghan
> INET: MonaghaS_at_mscdirect.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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 Aug 16 2000 - 13:01:48 CDT

Original text of this message

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