SQl for deleting Table

[marist89]

set pages 0
set trimspool on
set feedback off
set linesize 222
spool jh1.sql
select 'truncate table ' || owner || '.' || table_name || ';'
from dba_tables
where owner not in ('SYS','SYSTEM')
spool off

Then look at jh1.sql and run it...