Now I need some table data derived from the remote oracle database to a local file, then download the sqlulder2 toolkit, will sqlulder2. Exe program to copy to the local oracel bin directory for the client, after the command line input sqluldr2 carriage return, also can show the sqluldr2 hint information and various parameters with the help of the information, but the input sqluldr2 user=fact/QweTy @ sale qurey="select * from user" file=D: \ user CSV carriage return after the procedures are not performed, also does not have any error, sale is my local oracle client configured in a tnsname, can normal connection with plsqldev, my operating system is Windows XP,
Please advice what reason is this? How to solve?

CodePudding user response:

User is a keyword, are you sure you can create a table named user table?

CodePudding user response:

Switch to other table name is the same situation

CodePudding user response:

refer to the second floor mouse_txy response:

switch to other table name is the same situation

Try this:
. \ sqluldr2. Exe user=...

CodePudding user response:

You before the may not be the sqluldr2 versions of Windows

CodePudding user response:

Is windows32

CodePudding user response:

reference 5 floor mouse_txy reply:

is windows32 bit

The.exe suffix and try again?

CodePudding user response:

Since there is no error, that you export the d: \ user generated CSV yao

CodePudding user response:

Does it add. Exe.
D: \ user. CSV nor generated,

CodePudding user response:

refer to the eighth floor mouse_txy response:

add. Exe,
D: \ user. CSV nor generated,

Query in the query table for a table exists, will be what kind of?

CodePudding user response:

In existing card the same way

CodePudding user response:

See if the following situation:
https://www.cnblogs.com/it-abang/p/10069444.html
https://blog.csdn.net/sunwukong_hadoop/article/details/81218582