c:\progra~1\RESOUR~1\robocopy
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 03:04
I am trying to issue the following command in SQL*PLUS but it doesn't
like the space between 'program' and 'files'.
Can anyone tell me
Title: Message
I am trying to issue the following command in SQL*PLUS but it
doesn't like the space between 'program' and
'files'.
Can
anyone tell me how to get around this?
echo select 'host c:\program
files\resource kit\robocopy;' from dual;
Thanks!
Ron
Smith
Ron,
It works as you requested on 8.1.7.4.
Ron mª¿ªm
[EMAIL PROTECTED] 10/08/03 05:34PM
I am trying to issue the following command in SQL*PLUS but it doesn't
like the space between 'program' and 'files'.
Can anyone tell me how to get around this?
echo select 'host c:\program
Ron,
First of all, is echo a SQL*Plis command?
Secondly, I think this will do what you want:
select 'host c:\program files\resource kit\robocopy' from dual;
as long as what you want is to execute the robocopy program from the
SQL*Plus prompt.
If you want to do something else, clarify your
Sorry, this is what I am trying to run. But again, it barfs on the
'program files' portion of the script.
I have tried with and without quotes.
set heading off;
set feedback off;
set linesize 1000;
What is echo supposed to do? The proper command
should read like this:
select 'host /program\ files/resource\ kit/robocopy' from dual;
On Wed, 2003-10-08 at 17:34, Smith, Ron L. wrote:
I am trying to issue the following command in SQL*PLUS but it doesn't
like the space between 'program' and
Try using double quotes:
select 'host c:\program files\resource kit\robocopy
f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from
dual;
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Smith, Ron L.
Sent: Wednesday, October 08, 2003 5:05 PM
To: Multiple
Never mind. The error was related to another problem with the script.
Thanks!
Ron
-Original Message-
Sent: Wednesday, October 08, 2003 5:24 PM
To: Multiple recipients of list ORACLE-L
Try using double quotes:
select 'host c:\program files\resource kit\robocopy
Two options:
1. Change \program files\ to \program~1\
That should execute with no problems.
2. Another tact:
select 'host '||chr(34)||'c:\program files\resource kit\robocopy'||chr(34)||
' f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from
dual;
Ron,
one could include that directory in the path, then you would not have to provide the path in the command.
Pd"Smith, Ron L." [EMAIL PROTECTED] wrote:
I am trying to issue the following command in SQL*PLUS but it doesn't like the space between 'program' and 'files'.
Can anyone tell me how
10 matches
Mail list logo