-
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;
execute DBMS_UTILITY.ANALYZE_SCHEMA('52_DEV','COMPUTE');
exit
EOF
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|