Truncate/load within transaction

Question on feasability here. I've got a number of tables of moderate size (on the order of hundreds of thousands of rows) which we periodically (mostly daily) pull in from an external data source, via SQL*Loader. Question is - is it possible to provide transparancy of that data load, such that the truncate and table load happen within one transaction? I'd like to set things up such that others looking at this table see old data, and then see new data as soon as the load finishes. Right now, with a standard load, they see old data, then an empty table, then a growing table, and then a full table.

Thoughts? Many thanks in advance.

-Rick

+--------------------------------------------------------------------------+

|                 Rick Osterberg   osterber_at_fas.harvard.edu                |
|         Database Applications Specialist     FAS Computer Services       |


+--------------------------------------------------------------------------+