Re: Disabling indexes during data import

Michael,

My problem is that much of my structure is different than the original import. I did a lot of restructuring (losing old data in the process) and can't just do an import over top of my (new) tables. The other problem that I have is that I'm using a third party utility because my source data is in Paradox 7. I haven't found anything suggesting that SQL*Loader can import Paradox data directly.

Michael Bierenfeld wrote:

> Hello,
>
> I am afraid, but building indexes on large tables will possibly case
> your temporary segments to overflow. These Segments are used to store
> the "Temp" Data during Index creation.
>
> Perform the import in two steps :
>
> 1) Import the data with rows=no. These will create the tables and
> indexes
> 2) Import with ignore=yes buffer=100000 rows=yes full=yes. Import the
> data in exsiting structures commit every 100000 bytes. Ignore failures
> on table creation.
>
> Performance is an issue, but if you really have mass data it's IMHO the
> only way.
>
> Regards
>
> Michael

--
Ken Rachynski
Database Analyst
krachyn_at_cadvision.com
<http://www.cadvision.com/krachyn>
ICQ: 3113514 Received on Mon Feb 01 1999 - 17:14:38 CST