Q: Automatic jobs with Oracle 7.3.4

Hi

Looking forward to developping some automatic jobs on a daily basis I wonder how to do it.
A job is as follows:

set header off
set pagesize 0
spool c:\temp\users_tblsp.sql
select 'alter user '||username||' default tablespace temp temporary tablespace temp;'
from all_users
where username not like 'SYS%' and username not like 'DBS%'; spool off
set pagesize 1000
@c:\temp\users_tblsp.sql
set header on
set pagesize 100

Any idea? Thanks in advance.
--
Free audio & video emails, greeting cards and forums Talkway - http://www.talkway.com - Talk more ways (sm) Received on Tue Feb 22 2000 - 07:25:03 CST