>Beware, GTT and Truncates do not go together.. For what it's worth, this killed us too. The GTT were created ON COMMIT PRESERVE ROWS. The app reuses the table within a session. We all figured truncate reuse storage would be better than a delete. We figured wrong. -- http://www.freelists.org/webpage/oracle-l