For Oracle Database installs you might consider:
truncate table f989999 reuse storage ;
truncate table f989998 reuse stroage ;
instead of:
truncate table f989999 ;
truncate table f989998 ;
A) The truncate will run a bit faster, though it may be hard to measure. Truncate will run faster than DML, regardless, as it avoids the overhead of the delete statement.
B) If you're planning a full web gen, the tables will naturally move the high water mark back to near its original position.
If you use the 'reuse storage' option, it avoids the process of deallocating and reallocating the storage for the segment. Overall, it may be a more "nice" process for your database.
"To truncate a table or cluster, the table or cluster must be in your schema or you must have DROP ANY TABLE system privilege." - Oracle® Database SQL Reference