Creating a loaders in Oracle XE

[eduardo.d2]

Hello everyone, I would like to make a sql * loaders in Oracle Xe this is possible?
And how do I? I already made this type of load in 10g and it worked, already in the machine that owns Oracle Xe I can not get to have to start some function on this machine already thank you !!

[Trevisolli]

Topic moved to the dba's group.

[ruevers]

I do not know if xe has no ... but must have the sql loader yes and shot in 9 or 10 has to run on it too, anything if you do not have install a client of 10 that you have and you can do the load in the xe no problem.

[gilbertoca]

Hello everyone would like to make a sql * loaders in Oracle Xe this is possible?
And how do I? I already made this type of load in 10g and it worked, already in the machine that owns Oracle X and I can not be that I have to start some function in this machine already thank you very much !!

Oracle ex [url=http://download.oracle.com/docs/cd/B253 ... m#BCEIDEAG]Unloading and Loading Data

Gilberto

[eduardo.d2]

Many thanks work !!!

[eduardo.d2]

Hello everyone I created the loader but it is not loaded the records in the table. How do I increase the allowed errors of 50 to 60? And the error it is not allowing you to be entered in the CD_Salario field. Follow the example

Select all

   Nome da Coluna                  Posição   Tam  Term Incl Tipo de Dados 
------------------------------ ---------- ----- ---- ---- --------------------- 
CD_SALARIO                            1:5     5           CHARACTER             
SALARIO                              6:27    22           CHARACTER             
DEPARTAMENTO                        28:90    63           CHARACTER             
 
Registro 1: Rejeitado - Erro na tabela "SALARIO", coluna CD_SALARIO. 
ORA-01722: número inválido 
 
Registro 2: Rejeitado - Erro na tabela "SALARIO", coluna CD_SALARIO. 
ORA-01722: número inválido 
 
Registro 3: Rejeitado - Erro na tabela "SALARIO", coluna CD_SALARIO. 
ORA-01722: número inválido 
 
Registro 4: Rejeitado - Erro na tabela "SALARIO", coluna CD_SALARIO. 
ORA-01722: número inválido 
 
Registro 5: Rejeitado - Erro na tabela "SALARIO", coluna CD_SALARIO. 
ORA-01722: número inválido

Select all

Total de registros lógicos ignorados:          0 
Total de registros lógicos rejeitados:        51 
Total de registros lógicos descartados:        0 
Total de buffers de fluxo carregados pelo thread principal do SQL*Loader:        1 
Total de buffers de fluxo carregados pelo thread de carga do SQL*Loader:        0

Thank you very much for the help !!

[gilbertoca]

Hello everyone I created the loader but it is not loaded the records in the table. How do I increase the allowed errors of 50 to 60? And the error it is not allowing you to be entered in the CD_Salario field. Following the example

Select all

   Nome da Coluna                  Posição   Tam  Term Incl Tipo de Dados 
------------------------------ ---------- ----- ---- ---- --------------------- 
CD_SALARIO                            1:5     5           CHARACTER             
SALARIO                              6:27    22           CHARACTER             
DEPARTAMENTO                        28:90    63           CHARACTER             
 
Registro 1: Rejeitado - Erro na tabela "SALARIO", coluna CD_SALARIO. 
ORA-01722: número inválido 
 
Registro 2: Rejeitado - Erro na tabela "SALARIO", coluna CD_SALARIO. 
ORA-01722: número inválido 
 
Registro 3: Rejeitado - Erro na tabela "SALARIO", coluna CD_SALARIO. 
ORA-01722: número inválido 
 
Registro 4: Rejeitado - Erro na tabela "SALARIO", coluna CD_SALARIO. 
ORA-01722: número inválido 
 
Registro 5: Rejeitado - Erro na tabela "SALARIO", coluna CD_SALARIO. 
ORA-01722: número inválido

Check the client configuration. The location system (NLS_ *) needs to be in accordance with the data to be imported. If you use a comma or point as a decimal house, you use monetary or not, etc.

Gilberto

[eduardo.d2]

I did as I taught me

in the CTL file is in this way

Select all

 
 CD_SALARIO    	POSITION(1:10) 
,SALARIO 	                POSITION(11:20) 
,DEPARTAMENTO 	POSITION(21:122) 

The table that will receive the data também is of the same size

Select all

 
cd_salario number(10) 
salario      number(10) 
departamento varchar(102) 

Now I do not know why you are not loading !!

[gilbertoca]

Eduardo, I think you did not understand what you mean. I talked about the data to be imported, as they are in the text file, for example: there are accent character characters, the numbers use (.) As a decimal house - 1.6, 25.0, .25 -, etc.
So it is important to configure / set the location variables.

Gilberto

[eduardo.d2]

Gilberto was worth the help, what was happening was the positioning of the columns, I fixed and now it worked.

In the loader is in this way

Select all

 
   Nome da Coluna                  Posição   Tam  Term Incl Tipo de Dados 
------------------------------ ---------- ----- ---- ---- --------------------- 
CD_SALARIO                           1:10    10           CHARACTER             
SALARIO                                 11:19     9           CHARACTER             
DEPARTAMENTO                      20:50    31           CHARACTER    

in the CTL was in this way

Select all

 
 CD_SALARIO 	    POSITION(1:10) 
,SALARIO 	            POSITION(11:20) 
,DEPARTAMENTO   POSITION(20:50) 

and in Oracle

Select all

 
CD_SALARIO  NUMBER(10) 
SALARIO        NUMBER(8) 
DEPARTAMENTO VARCHAR2(50) 

corrected and stood in this way
in the loader is in this way

Select all

 
   Nome da Coluna                  Posição   Tam  Term Incl Tipo de Dados 
------------------------------ ---------- ----- ---- ---- --------------------- 
CD_SALARIO                           1:10    10           CHARACTER             
SALARIO                                 11:19     9           CHARACTER             
DEPARTAMENTO                      20:50    31           CHARACTER    

in CTL It was in this way

Select all

 
 CD_SALARIO 	    POSITION(1:10) 
,SALARIO 	            POSITION(11:19) 
,DEPARTAMENTO   POSITION(20:50) 

and in Oracle

Select all

 
CD_SALARIO  NUMBER(10) 
SALARIO        NUMBER(9) 
DEPARTAMENTO VARCHAR2(31) 

again thank you and even +