Home » RDBMS Server » Server Utilities » Blank fields with sql*loader (Oracle 9i)
Blank fields with sql*loader [message #319924] Tue, 13 May 2008 07:15 Go to next message
binho_sjc
Messages: 8
Registered: April 2007
Junior Member
Hi everybody.
Im trying to use sql*loader and I got a problem.
There is no errors described in log file but actually at the table are just blank fields and records.
Any ideas?

Below is the code of control file.

Load Data
infile 'C:\Sistemas\VirtualEduca\Loader\carga\ve_congresso.txt'
badfile 'C:\Sistemas\VirtualEduca\Loader\BAD\ve_congresso.BAD'
append
into table tb_carrega_ve_cadastro
fields terminated by ';'
trailing nullcols
(
INSCRICAO
,DTINSCRICAO
,CPF
,NOME
,NOME_CRACHA
,SEXO
,ENDERECO
,CIDADE
,ESTADO
,CEP
,PAIS
,PASSAPORTE
,TELEFONE
,CELULAR
,NECESSIDADE
,TIPONECESSI
,EMAIL
,DTNASC
,EMPRESA
,CARGO
,PROFESSOR_REM
,MATPMSJC
,M1
,T1
,M2
,T2
,M3
,T3
,VALOR
,DTBAIXA
,CONFIRMADO
,CONVITE_M1
,CONVITE_T1
,CONVITE_M2
,CONVITE_T2
,CONVITE_M3
,CONVITE_T3
,ANO
)


create table TB_CARREGA_VE_CADASTRO
(
INSCRICAO VARCHAR2(50) not null,
CONFIRMADO VARCHAR2(20) not null,
DTLIMITE DATE,
DTBAIXA VARCHAR2(50),
NOME VARCHAR2(200) not null,
CPF VARCHAR2(54) not null,
M1 VARCHAR2(50) not null,
T1 VARCHAR2(50) not null,
M2 VARCHAR2(50) not null,
T2 VARCHAR2(50) not null,
M3 VARCHAR2(50) not null,
T3 VARCHAR2(50) not null,
VALOR VARCHAR2(50),
ENDERECO VARCHAR2(200),
CIDADE VARCHAR2(50),
CEP VARCHAR2(20),
ESTADO VARCHAR2(50),
PAIS VARCHAR2(100),
TELEFONE VARCHAR2(60),
CELULAR VARCHAR2(60),
EMAIL VARCHAR2(100) not null,
SEXO VARCHAR2(50) not null,
TRATAMENTO VARCHAR2(20),
NECESSIDADE VARCHAR2(50) not null,
TIPONECESSI VARCHAR2(100),
DTNASC VARCHAR2(50),
EMPRESA VARCHAR2(150),
CARGO VARCHAR2(150),
MATPMSJC VARCHAR2(50),
CONTPMSJC VARCHAR2(50),
NIVEL VARCHAR2(40),
DTINSCRICAO VARCHAR2(50),
ANO VARCHAR2(50),
PROFESSOR_REM VARCHAR2(50),
CONVITE_M1 VARCHAR2(50),
CONVITE_T1 VARCHAR2(50),
CONVITE_M2 VARCHAR2(50),
CONVITE_T2 VARCHAR2(50),
CONVITE_M3 VARCHAR2(50),
CONVITE_T3 VARCHAR2(50),
INSCRICAO_ATIVA VARCHAR2(6),
CO01 VARCHAR2(1),
CO02 VARCHAR2(1),
CO03 VARCHAR2(1),
CO04 VARCHAR2(1),
CO05 VARCHAR2(1),
CO06 VARCHAR2(1),
CO07 VARCHAR2(1),
CO08 VARCHAR2(1),
CO09 VARCHAR2(1),
CO10 VARCHAR2(1),
CO11 VARCHAR2(1),
CO12 VARCHAR2(1),
CO13 VARCHAR2(1),
CO14 VARCHAR2(1),
CO15 VARCHAR2(1),
CO16 VARCHAR2(1),
CO17 VARCHAR2(1),
CO18 VARCHAR2(1),
CO19 VARCHAR2(1),
CO20 VARCHAR2(1),
CO21 VARCHAR2(1),
CO22 VARCHAR2(1),
CO23 VARCHAR2(1),
CO24 VARCHAR2(1),
CO25 VARCHAR2(1),
CO26 VARCHAR2(1),
CO27 VARCHAR2(1),
CO28 VARCHAR2(1),
CO29 VARCHAR2(1),
CO30 VARCHAR2(1),
CO31 VARCHAR2(1),
CO32 VARCHAR2(1),
CO33 VARCHAR2(1),
CO34 VARCHAR2(1),
CO35 VARCHAR2(1),
CO36 VARCHAR2(1),
CO37 VARCHAR2(1),
CO38 VARCHAR2(1),
CO39 VARCHAR2(1),
CO40 VARCHAR2(1),
CO41 VARCHAR2(1),
CO42 VARCHAR2(1),
CO43 VARCHAR2(1),
CO44 VARCHAR2(1),
CO45 VARCHAR2(1),
CO46 VARCHAR2(1),
CO47 VARCHAR2(1),
CO48 VARCHAR2(1),
PASSAPORTE VARCHAR2(50),
NOME_CRACHA VARCHAR2(50)
)
tablespace VTEDUCA_TS
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
Re: Blank fields with sql*loader [message #319932 is a reply to message #319924] Tue, 13 May 2008 07:28 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- File is empty
- There is no ';' in the line

That are the first 2 ideas that come in my mind.

Regards
Michel

Previous Topic: How to load data using SQLLDR from multiple tables.(Urgent)
Next Topic: No required contents im view v$logmnr_contents
Goto Forum:
  


Current Time: Sun Dec 04 20:46:08 CST 2016

Total time taken to generate the page: 0.23718 seconds