truncate a global temporary table
SQL> SQL> create global temporary table sess_event 2 on commit preserve rows 3 as 4 select * from v$waitstat 5 where 1=0 ; SQL> SQL> truncate table sess_event; Table truncated. SQL> SQL> drop table sess_event; Table dropped. SQL> SQL> --