This content has been marked as final. Show 7 replies
You will have to see if Linux interprets the $ as special character.
Ask the Sys Admin.
If this is the case, it does not matter what you do in Master SQL script.
If Linux interprets $xyz123 as environmental variable, does not find, then looks for file named abc[null].sql
Then you must do the rename.
If you use Linux commands: ls -1 > temp.file
Then temp.file will have all the files in the directory.
Use vi editor and substitution variables to create individual commands to rename each file without the $.
Then execute temp.file
Do Ask Sys Admin before doing this
Thanks. As I said in my original post, escaping didn't work.
I ran into the thread below, and it appears to be a sqlplus 10.2.0.1.0 client bug. Is there a workaround?
10.2 client - Cannot open file with $ in the name
989748 wrote:Please don't drag up old threads, there's little benefit.
I have faced the similar issue. problem was cfg ascii file was transfered in binary mode to unix box, script will take the file name from that cfg file and extra character was coming in filename[\r]. i have tranform to unix style using dos2unix command and it starts working fine.