-
Title
"The filename, directory name, or volume label syntax is incorrect" when running DATACOPY -
Description
I have successfully run this feature using the interactive panel from Schema Browser, but I want to run from DOS command line. I execute the command supplied in the script, but get the following error.
C:\Program Files\Quest Software\Toad for Oracle\toad.exe" -c MYSCHEMA/<8,0,0,0,181,115,38,78,110,97,34,55,205,59,244,246,169,60,183,183>@MYDB DATACOPY="C:\test\port_file.txt"
"The filename, directory name, or volume label syntax is incorrect." -
Cause
The command produced in the settings file is incorrect. There should be double quotes around the connection string.
-
Resolution
WORKAROUND
Add double quotes around the connection string i.e.
C:\Program Files\Quest Software\Toad for Oracle\toad.exe" -c "MYSCHEMA/<8,0,0,0,181,115,38,78,110,97,34,55,205,59,244,246,169,60,183,183>@MYDB" DATACOPY="C:\test\port_file.txt"
STATUS
Issue is fixed in version 9.7.2.5.The latest version of Toad for Oracle can be downloaded at the Support Portal.
Click here.