I am mucking through my first real perl script. When it is finished it will install statspack on all of the database throughout the company. That's a gob of databases!
To run in batch mode statspack requires two define statements: define default_tablespace = tablespace_name define temporary_tablespace = temp_name Does anyone know the syntax to get these two statements to work? If not, I suppose the individual scripts can be called individually after the perfstat user is created. Either that or chicken out of the perl stuff and go back to tried and true shell scripting. ===== Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
