Re: data load into partition table

Does this mean that uses could also be inserting new data into the partition at the same time ? If not you could try something like:

Create temp_table as select * from partition; SQL*Load into temp_table;
index temp_table;
exchange;

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

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



bsonia_at_my-deja.com wrote in message <92tmhi$oh6$1_at_nnrp1.deja.com>...


>This sounds great if there isn't any data existing in the partition

>before the load.

>

>What if there is?

>

>Bill Sonia

>Achaia Solutions, Inc

>