SQL*Loader-704 & ORA-12560
Hi my oracle friends...
I'm getting this error when trying to use sqlldr:
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12560: TNS:protocol adapter error
I'm using this control file:
LOAD DATA
INFILE 'c:\exportmysql.exp'
BADFILE 'c:\badfile.txt'
APPEND
INTO TABLE HISTORICODAF
FIELDS TERMINATED BY '|'
(
CODIGOHISTORICO INTEGER EXTERNAL,
CODIGODAF CHAR,
TIPORESPOSTA CHAR,
DATASISTEMA DATE 'DD/MM/YYYY HH24:MI:SS',
VELOCIDADE FLOAT EXTERNAL,
PROA FLOAT EXTERNAL,
GEOMETRY COLUMN OBJECT
(
SDO_GTYPE INTEGER EXTERNAL,
SDO_SRID INTEGER EXTERNAL,
SDO_POINT COLUMN OBJECT
(X FLOAT EXTERNAL,
Y FLOAT EXTERNAL)
),
CODIGOUSUARIO CHAR,
CODIGOEMPRESA CHAR,
CODIGOOBJETO CHAR,
DATAINICIOBUSCA DATE 'DD-MM-YYYY HH24:MI:SS',
DATAFIMBUSCA DATE 'DD-MM-YYYY HH24:MI:SS',
ESTADO CHAR,
DATAGPS DATE 'DD-MM-YYYY HH24:MI:SS',
DATAEQUIPAMENTO DATE
)
And I'm using the right command-line:
sqlldr userid=daf/fad control=c:\control.ctl log=c:\sqlldr.log
Another doubt is: how Oracle knows wich of my services they need to connect?
Can I pass this in sqlldr command-line parameters or control file?
Thanks 4 all...