On Fri, 15 Jan 1999, Imel Rautenbach wrote:
> Hi.
>
> I am doing a import of large tables (500K to 2M records.)
> While the table is being imported I cannot see any datafiles grow.
> where does it load the data before it shows the no_of_recs in the import
> screen?
>
> Many Thanks
> Imel
>
Imel,
The data is loaded into the ROLLBACK segment and not into the table. Right
before the index is created, Oracle implicitly COMMITs the data. At this
point, it is applied to the datafile.
If you don't want this to happen, you can use COMMIT=Y during your import.
Depending on how your rollback segments are configured, you can also
dramatically improve the time needed to import your data.
Best regards,
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 245+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page