I have a cronjob setup to analyze the tables daily in development and qa environment and it works fine.
The script is as following:
sqlplus internal <
col total format 9,999,999,999
alter tablespace temp coalesce;
However I didn't have a privilege to use internal and I don't want to hardcode the schema name and password in customer's production system. Any suggestions?