Originally posted by PMCS
Well , this table is used as a temp table and will be deleted as well when the job completes.
That's exactly what a GTT would do nicely. Create it once and the data's cleaned out automatically at the end of the session, only the definition remains. OK, there are some limitations and the CBO can have probs with them (no stats, unless you fudge them): http://download-west.oracle.com/docs...3a.htm#2061433