This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / I want to ask question about Oracle: ThanksI wrote a vb program, which exports data from excel to oracle by sql loader. It runs well in my machine where there is only one oracle database, and the server and client are located.
When my customer use it, there are two problems:
1. The log file (for the control file) was created, but it is blank.
2. If there are 2 databases on the server, will Sql loader find the right one.
(for the second question, i am not sure exact concept)
Thanks
-lilyba(Sunshine);
2002-3-28
{451}
(#423475@0)
-
up
-lilyba(Sunshine);
2002-3-28
(#423512@0)
-
up
-lilyba(Sunshine);
2002-4-1
(#429847@0)
-
up
-lilyba(Sunshine);
2002-4-1
(#429887@0)
-
you must use tns name to point out which server you want to connect.
such as scott/tiger@test test is a tnsname, Tns configuration file will be located in $ORACLE_HOME/network/admin/tnsnames.ora
-arthurxu(arthur);
2002-4-2
(#431320@0)
-
I tried to add tnsname, but my customer still got empty log file. Are there any other reason for empty log file. (I know if the path name is too long, it will cause this problem.)
-lilyba(Sunshine);
2002-4-3
(#433553@0)
-
Can they connect to the destination DB by SQL*Plus? If there's no problem with network setting, try to use SQL*Loader command in DOS. See what will happen.
-cyt(Work for Friday);
2002-4-3
(#433818@0)
-
Thanks. I am an Oracle dummy. I think that might be the reason too. Since I knew nothing about their Oracle setting. His machine does not have sqlldr first.Now, I asked them to change oracle client to have "database administration"
-lilyba(Sunshine);
2002-4-3
{77}
(#433831@0)