Mega Code Archive
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> --