Re: Direct LOAD - UNRECOVERABLLE - Question

Absolutely right.

After a direct load, SQL*Load creates a 'mini' index on the new data, then merges it with the old data by copying. So temporarily the tablespace needs to be able to hold two complete copies of the index.

As you say, if there isn't enough space, the copy/merge fails and the index stays in Direct Load state.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Lothar Armbrüster wrote in message
<1396.789T649T12292928lothar.armbruester_at_rheingau.netsurf.de>...
>
>I have observed that the loader need huge amounts of tablespace when
>rebuilding the indexes. If the free space does not suffice, recreating the
>indexes after the load may use much less tablespace.
>
Received on Fri Apr 30 1999 - 17:04:52 CDT