RE: create a batch file to execute script

Good Point!

I think you can eliminate that by making the first line of the script the connect string.

If I am incorrect, I am sure someone on the list will respond......

Steve Monaghan
Worldcom

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Smith, Ron
> L.
> Sent: Friday, June 09, 2000 11:12 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: create a batch file to execute script
>
>
> Be careful with scripts like this. Anyone can see the password
> on Unix with
> the PS command.
> Ron Smith
> Database Administration
> rlsmith_at_kmg.com
>
>
> -----Original Message-----
> Sent: Friday, June 09, 2000 9:25 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I would recommend either calling the second script at the end of the first
> script,
> or
> making a third script that simply calls the other two:
> plus33.exe scott/tiger_at_my_db @script3
>
> script3.sql::
> @@script1
> @@script2
> exit
>
> HTH,
> Steve Monaghan
>
> > -----Original Message-----
> > From: B, Ravindra [mailto:Ravindra.B_at_Compaq.com]
> > Sent: Friday, June 09, 2000 12:42 AM
> > To: 'ORACLE-L_at_fatcity.com'
> > Cc: 'Steve.Monaghan_at_wcom.com'
> > Subject: RE: create a batch file to execute script
> >
> >
> > Steve,
> >
> > Thanks for the mail.It worked for me.
> >
> > What if I want to execute two scripts in the same sqlplus session.
> > I tried
> >
> > plus33.exe scott/tiger_at_my_db @script1 @script2
> >
> > But this doesn't work.The second script doesn't get executed.
> >
> > How can I do this.Pls advice.
> >
> > Regards,
> > Ravindra
> >
> > -----Original Message-----
> > From: Steven Monaghan [mailto:Steve.Monaghan_at_wcom.com]
> > Sent: Thursday, June 08, 2000 11:16 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: create a batch file to execute script
> >
> >
> > Put parameters after the executable.
> >
> > First parameter is the login.
> > Second is the script.
> >
> > plus33.exe scott/tiger_at_my_db @script1
> >
> > We do this all the time here on NT. Works file. We even have
> > looping batch
> > files to kick off scripts every so many minutes. Put an exit at
> > the end of
> > the script if you want the window to close when done.
> >
> > Steve Monaghan
> > Worldcom
> >
> > > -----Original Message-----
> > > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
> B, Ravindra
> > > Sent: Thursday, June 08, 2000 10:18 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: create a batch file to execute script
> > >
> > >
> > > How can i create a batch file under windows Nt platform that
> will invoke
> > > sqlplus and run a
> > > sql file for me.i was able to create a batch file that will
> execute the
> > > plus33.exe and log in
> > > as system user.But i was not able to get the script (c.sql) executed.
> > >
> > > pls advice
> > >
> > > thanks,
> > > ravindra
> > > --
> > > Author: B, Ravindra
> > > INET: Ravindra.B_at_compaq.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (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).
> > >
> >
> > --
> > Author: Steven Monaghan
> > INET: Steve.Monaghan_at_wcom.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (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).
> >
>
> --
> Author: Steven Monaghan
> INET: Steve.Monaghan_at_wcom.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
Received on Fri Jun 09 2000 - 09:51:44 CDT