SQL & PL/SQL

We currently have a table build procedure that runs nightly to create our data warehouse. This procedure is spinning off too many archive/logging files.

The procedure does a truncate/replace nightly

eg -

truncate table lifcdw_staging.tablename;

insert into lifcdw_staging.tablename
select a.name, a.territory
from sales_reps a
where a.territory_region='east'


we tried to add the following hint:

INSERT /*+ append nologging */ into lifcdw_staging.tablename

this seems to work ok when individual parts of the script are run but if i execute the procedure via toad, the whole thing finishes in about 3 seconds (normally takes over an hour). Obviously it is not running correctly as a procedure with the hint in each insert statement. I have compiled with debug and found no errors.

any help is appreciated.

Jason