Re: exchange partition in 8i

Yes, Yes and Yes.

I am a great believer in using PL/SQL wrappers to read and execute SQL statements from files, and a strategy I used quite often is:

    sql*load data into temp table
    sql to do bulk massage of data
    sql to rebuild data segment if smashed     sql to create indexes
    exchange partition

The last 4 stages would be designed as an anonymous PL/SQL block, to allow easy
and clean error trapping.

As far as speed is concerned on the EXCHANGE - you need to be aware of the effects of constraints and 'with/without validation' clause of exchange. This varies dramatically from 8.0 to 8.1 (and is described in my book).

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

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Jay B. McCoy wrote in message <99asdm$q6j_at_ftp.ee.vill.edu>...


>Has anyone used exchange partition/insert into partition for performing

>large data warehouse loads?  Were you able to automate the partition

>creation, index creation, constraints etc?  Did you notice an improved

>performance over the typical drop index, extract data, transform and load

>data into fact table?

>

>