You could create a sequence and use that in the file name OR use sys_context('USERENV','SESSIONID') - either way every logon will have a unique file name. eg:
select to_char(sysdate,'DDMONYYYY')||'_'||sys_context('USERENV','SESSIONID') l_date from dual;




Reply With Quote