Re: imp commit=n and rbs

"Joel Garry" <joel-garry_at_home.com> wrote in message news:91884734.0304281606.182d772b_at_posting.google.com...
> Well maybe, but more than 5 times the table size? I'm tellin' ya, my
> "something weird this way comes" light is flashing brightly.

IIRC Imp also does an analyze which may/will generate undo. On the other hand (and I guess block dumps are probably the way to answer definitively) more than 5 times the size and '5 indexes' seem suspiciously close to me. If I produce an indexfile from an import and parse out only the create statements I get

CREATE INDEX <OWNER>.<NAME> ON <TABLE_NAME>(<COLUMN_LIST>) .... LOGGING; for each index. Now I believe that you always get UNDO generated when you make a block modification and so as well as the rowids (and column values) that Norman talks about you will I imagine get UNDO for the block changes to the base tables block headers. This looks like quite a good argument for producing the indexfile as I said above and modifying LOGGING; to NOLOGGING;

I'll pass on the opportunity to comment on COMPRESS=Y just this once :)

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK