It could be faster to remote copy: rcp -p /archive/orcl/arch_1_2290.arc oracle@server2:/archive/orcl/arch_1_2290.arc
Mike >From: "Thomas, Kevin" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Unix - script >Date: Wed, 09 Jan 2002 00:35:23 -0800 > >Forgot to mention, the 'cd scripts' line in both examples is not required, >it's just been left in from the script I copied. oops! >K. > >-----Original Message----- >Sent: 09 January 2002 08:20 >To: Multiple recipients of list ORACLE-L > > >Roland, > >Try this by setting up environment variables at the top of your script: > >SERVER1= 10.10.10.10 >USER1= 'xxx' >PWD1= 'xxx' >SERVER2= 10.10.10.20 >USER1= 'yyy' >PWD2= 'yyyy' > >Then have this: > >ftp -i -n << EOF >open $SERVER1 >user $USER1 $PWD1 >cd scripts >get <file> >close >EOF > >You can then have a section like the one below if you want to copy to a >different server >other than the one you are running this script from: > >ftp -i -n << EOF >open $SERVER2 >user $USER2 $PWD2 >cd scripts >put <file> >close >EOF > >Both of these can be included in the one shell script. > >Hope that helps. >Kev. > > >'In Windows no one can hear you scream' >__________________ > >Kevin Thomas >Technical Analyst >Deregulation Services >Calanais Ltd. >(2nd Floor East - Weirs Building) >Tel: 0141 568 2377 >Fax: 0141 568 2366 >http://www.calanais.com > > > > > >-----Original Message----- >Sent: 09 January 2002 07:16 >To: Multiple recipients of list ORACLE-L > > >Hallo, > >I would like to have an example of a unix script, which does the following: > >copy some files from directory /prod/sas/data located at "hardy".(which is >a computer) >to the other database hakon. Is it possible to do this. Please help me >quick. > > >Thanks in advance > >Roland S > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >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: [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.com >-- >Author: Thomas, Kevin > INET: [EMAIL PROTECTED] > >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: [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.com >-- >Author: Thomas, Kevin > INET: [EMAIL PROTECTED] > >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: [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). _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] 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: [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).