Xref: alice comp.databases.oracle:75125 comp.databases.oracle.misc:35529 comp.databases.oracle.server:56351
Path: alice!news-feed.fnsi.net!netnews.com!howland.erols.net!newsfeed.cwix.com!209.208.190.2!news.globix.net!uunet!nyc.uu.net!ffx.uu.net!in5.uu.net!feedme.ziplink.net!petpeeve.ziplink.net!not-for-mail
From: "Sinead" <kbsq@ziplink.net>
Newsgroups: comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server
References: <7lvj1m$lnp$1@ssauraac-i-1.production.compuserve.com>
Subject: Re: Data record import
Lines: 10
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <9MJg3.578$Wu4.9058@petpeeve.ziplink.net>
Date: Wed, 7 Jul 1999 10:47:46 -0400
X-Trace: petpeeve.ziplink.net 931358853 192.250.112.101 (Wed, 07 Jul 1999 10:47:33 EDT)
NNTP-Posting-Date: Wed, 07 Jul 1999 10:47:33 EDT


Few Suggestions
1) Check that the Table is sized correctly, it may be running out of space .
2) Check that all indexes (+Primary Keys Indexes) are sized correctly.
Maybe remove them while the load is running and create them.
3) Ensure no triggers are enabled on table.
4) Also try changing parameters like rows and bindsize
5) Maybe look into using Direct path