Recently did an export work, in the process of using Xshell, found in their own computer with the CMD command to export the DMP file, in the Xshell tool to export the times wrong.
Commands executed on CMD: exp ***/*** @oracle file=d:\tbissamt.dmp tables= (tbissamt) query=\ "where trans_date> ' 20150814 ' \"
Commands executed on Xshell: Exp ***/*** @oracle file=tbissamt.dmp tables=\ (tbissamt\) query=\ "where trans_date\> ' 20150814 ' \"
Use the Xshell tool to export, the compiler in the use of the same with the CMD compiler, so you want to add a special character above the turn, a slash \.
After exporting, it is possible to report a character encoding inconsistency, because we export the DMP file on the server, the encoding on the server is different from the encoding used by Xshell, the encoding on the server is set to Xshell encoding. Export and then set back.
Use Xshell to export Oracle DMP files, plus query criteria