Re: DIRECT=Y with EXP

Hi Denis,

in addition to the remarks you received to your question:

if you have a table with a lot of chained or migrated rows your exp may take eternities. We had a table which did not finish after ten hours (we monitored the progress with feedback=10000 to print a dot each 10000 processed rows). The conventional took two hours. (After importing, the newly imported table took only one hour to directly exp.) The table had around 30,000,000 rows of which 20,000,000 were migrated (due to a bad application design doing lots of updates in varchar2 (255)!). The database then was 8.1.6.3.0 on Sun Solaris 2.6

Regards,

Martin

Epicentre team A wrote:
>
> Hi
>
> Why this option is never the default option ?
> What are possible problems to export always with DIRECT=Y for bypass sql
> processing on SGA
>
> system configuration: Oracle 8.1.7, NT 2000 Server.
>
> Thanks
> Denis Jeanneret
Received on Tue Aug 06 2002 - 11:04:09 CDT