Hi, Here is a little something I do to execute sqlplus commands from shell scripts. This is just a snippet from a database startup script, so you'll have to season to taste. This should get you started in the right direction.
sqlplus /nolog <<EOF connect / as sysdba startup EOF Hope this helps Iman -----Original Message----- From: John [mailto:[EMAIL PROTECTED] Sent: Friday, December 26, 2003 3:38 PM To: dbi-users Subject: Re: Automatng import Quoting Kevin Moore <[EMAIL PROTECTED]>: > Try "drop user jim cascade" > > John wrote: > > >Hi all > > > >I am planning to make a cronjob so i would like to know if tht can be > achived through a perl script. > > > >To be more specific, i have an Oracle RDBMS and i want to execute some > commands in the shell > > > >..... > >system("sqlplus system/password"); > >system("drop jim cascade"); > >........ > > > > > >can be the above done? To execute internal commands as the sqlplus programs > provides? > > > > > > I am afraid that this trick isn't going to work as far as system() will be waiting until the sqlplus command ends. What do you say?
