Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to copy files with SQLPLUS

Re: How to copy files with SQLPLUS

From: RSH <RSH_Oracle_at_worldnet.att.net>
Date: Thu, 25 Apr 2002 14:06:10 GMT
Message-ID: <m3Ux8.45032$Rw2.3523490@bgtnsc05-news.ops.worldnet.att.net>


This begs the question of why one would be bothering to invoke SQL*PLUS for O/S file copy operations; I am presuming this is because it might be something like copying old log files to somewhere else so they're not overwritten, etc?

Which is quite a good idea that a lot of people forget; or even just a brutal

spool off
!rm booga.log
spool booga.log

to avoid the nightmare of neverending spool files.

RSH. "Knut Talman" <knut.talman_at_mytoys.de> wrote in message news:3CC807AC.6080109_at_mytoys.de...
> Epicentre Team A ANNECY wrote:
>
> > I want to include the copy command in a sql script !
>
>
>
> SQL> !cp ...
>
> or
>
> SQL> host cp ...
>
> or (Windoze)
>
> SQL> $copy ...
>
>
> Regards,
>
> Knut
>
Received on Thu Apr 25 2002 - 09:06:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US