phil,
i'd suggest looking at partitioned tables. using this you can create
indexes that are local to each partition.
eg, you may partition a table based on BatchId (?), doing an
'alter table add partition '
for each import.
in theory (hehe) this should let you create a new partition, disable
its index (currently no rows), import 100k records, enable index (100k
rows)..
try it and see what happens.. i haven't done any of this stuff in
practice :-) oracle will be able to do it one way or the other.. may
want to talk to oracle themselves and see what they suggest?!?
(chris's email with the same suggestion just arrived..) ah well :-)
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
