Re: Imports and Redo logs

I do believe that imports work exactly like an insert statement. First the tables are created, then the data is inserted.

BUT, there is always the excellent DIRECT=YES flag for the importer. I don't know if that does anything different with redo logs though. I would think it would but I'm not sure.

Lyall Barbour

At 06:46 AM 8/16/00 -0800, you wrote:
>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 - 12:56:07 CDT