Jared, You came to the same conclusion I did. Since this is the first perl script I have written for production I still have a lot to learn. I was thinking that I had missed something painfully obvious.
Thanks for the help. Hope all is well by you. Pete --- [EMAIL PROTECTED] wrote: > Pete, > > Even as a rabid Perl fanatic, I still use KSH to > install statspack. > > I just modified the stock scripts a bit so they will > run without user > input. > > You can do it in Perl, but ksh is probably the tool > for this job. > > Jared > > > > > > > Peter Barnett <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/14/2003 03:49 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject: Perl Question > > > 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). > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: > 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). ===== 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).
