-- alert_log_tmp_table.sql
-- create the global temp table used
-- by the alert log

-- 'preserve rows' is used so that file info
-- may be viewed for duration of session

drop table dirlist;

create global temporary table dirlist ( 
	directoryname varchar2(30)
	, filename varchar2(255)
	, filesize number 
	, filedate date
)
--on commit delete rows
on commit preserve rows
/