-
Title
Error "The system cannot find the file specified " when running 'copy data to another schema' fr -
Description
Ran Schema Browser | tablename | 'Copy Data to another schema' and created the settings command file for this to be run subsequently in the Dos Command line.
The following was detailed in the comments of the file:
"C:\Program Files\Quest Software\Toad for Oracle 9.1\toad.exe" -c MYSCHEMA/<4,0,0,0,182,192,18,113,53,87,14,99,165,69,185,71,197,138,232,6>@MYDB DATACOPY="C:\Documents and Settings\MyUser\My Documents\teststuff\Test Exports\test copy data to schema.txt"
On running the above command in the Dos Command Line the following error occurs:
"The system cannot find the file specified: -
Cause
Information in the settings file comments, detailing how to run from the command line, is incorrect. There should be double-quotes around the connection string
-
Resolution
WORKAROUND:
Instead of, for example:
"C:\Program Files\Quest Software\Toad for Oracle 9.1\toad.exe" -c MYSCHEMA/<4,0,0,0,182,192,18,113,53,87,14,99,165,69,185,71,197,138,232,6>@MYDB DATACOPY="C:\Documents and Settings\MyUser\My Documents\teststuff\Test Exports\test copy data to schema.txt"
The correct format should read:
"C:\Program Files\Quest Software\Toad for Oracle 9.1\toad.exe" -c "MYSCHEMA/<4,0,0,0,182,192,18,113,53,87,14,99,165,69,185,71,197,138,232,6>@MYDB" DATACOPY="C:\Documents and Settings\MyUser\My Documents\teststuff\Test Exports\test copy data to schema.txt"
Note the double-quotes around:
MYSCHEMA/<4,0,0,0,182,192,18,113,53,87,14,99,165,69,185,71,197,138,232,6>@MYDB
STATUS:
Issue fixed in version 9.7.2.5. The latest version of Toad for Oracle can be downloaded at:
http://support.quest.com/support_download/Downloads.asp