When I tried to run sqlldr and got the following error message:
dos>sqlldr usrid@db control=file.ctl dir
ect=true
Password:
SQL*Loader: Release 7.3.4.0.0 - Production on Tue Aug 15 11:33:45...
http://www.experts-exchange.com/Database/Oracle/Q_11010342.html
Zones:
OracleDate Answered: 08/18/2000 Grade: C Views: 8
I'm trying to execute the SQL*LOADER for the first time in a newly creaded UNIX account.
at the $prompt I typed:
sqlldr userid=login/pasword control=SQLLoaderControl.ctl log=Uclass2.log
it r...
http://www.experts-exchange.com/Database/Oracle/Q_20111389.html
Zones:
OracleDate Answered: 06/04/2002 Grade: A Views: 4
How does sqlldr process the data from an input file?
If I have a data file in the following format
header ........
detail ........
detail ........
detail .......
header .....
detail .......
http://www.experts-exchange.com/Database/Oracle/Q_20152623.html
Zones:
OracleDate Answered: 07/19/2001 Grade: B Views: 0
Hello,
my table a with 3 column:
nr1 number,
datum date,
nr number
LOAD DATA
INFILE *
INTO TABLE a
append
FIELDS TERMINATED BY ';'
(NR1,
DATUM "to_date(:datum,'HH24:MI:SS')",
NR
...
http://www.experts-exchange.com/Database/Oracle/Q_20286065.html
Zones:
OracleDate Answered: 04/08/2002 Grade: A Views: 87
Does anybody know how to execute sqlldr from within a sql shell script? Something like:
select sysdate from dual;
@ /sqlldr apps/apps@db data.ctl;
select sysdate from dual;
http://www.experts-exchange.com/Database/Oracle/3rd_Party_Tools/Q_20403734.html
Hi,
I have a table with three colums:
name email phone
joe aaa 111
john bbb 222
.
.
how can I change the phone column without the email
column using sqlldr?
...
http://www.experts-exchange.com/Database/Oracle/Q_20528845.html
Zones:
OracleDate Answered: 02/26/2003 Grade: A Views: 0
http://www.experts-exchange.com/Database/Oracle/Q_20558827.html
Zones:
OracleDate Answered: 05/10/2004 Grade: A Views: 0
is sqlldr works in oracle 8 on NT ?
if ok, my problem is
student table is already created
ctl file:
LOAD DATA
INFILE 'STUDENT.DAT'
INTO TABLE STUDENT
(stu_no POSITION(01:04) number,...
http://www.experts-exchange.com/Database/Oracle/Q_20639009.html
Zones:
OracleDate Answered: 06/06/2003 Grade: B Views: 9
when i execute the sqlldr at command prompt, i get the message "commit point reached - logical record count 7"
but i dont see the data in the table.
help!
thanks
http://www.experts-exchange.com/Database/Oracle/Q_20859089.html
Zones:
OracleDate Answered: 01/22/2004 Grade: B Views: 0
I have a flat file with fixed length fields where there is no character that terminates the field.
I'm trying to set up an external table and it wants a 'field terminated by'.
What can I use here?
http://www.experts-exchange.com/Database/Oracle/Q_21090514.html
Zones:
OracleDate Answered: 08/11/2004 Grade: A Views: 4
