SQL Loader [message #72566] |
Fri, 18 July 2003 09:47 |
Francisco
Messages: 4 Registered: October 2002
|
Junior Member |
|
|
Hi all,
i've tried to use SQL Loader but i receive this error:
------------------------------------------------------
SQL*Loader-941: Error during describe of table SA.TB_LOCALIDADE
ORA-04043: object SA.TB_LOCALIDADE does not exist
------------------------------------------------------
where SA is the Schema and TB_LOCALIDADE is the table....
Can sombody help me?
Thnks
Francisco Espinoza
|
|
|
|
Re: SQL Loader [message #72568 is a reply to message #72567] |
Fri, 18 July 2003 11:28 |
Francisco Espinoza
Messages: 1 Registered: July 2003
|
Junior Member |
|
|
Hi,
this is the control file....
--
-- Copyright (c) 2002 Oracle Corporation. All rights reserved.
--
LOAD DATA
APPEND
into table tb_localidade
fields terminated by ','
(IDT_LOCALIDADE,
NOM_LOCALIDADE,
DAT_ULT_ATUALIZACAO,
COD_USUARIO,
TIMESTAMP)
------------------------
I´ve tried to load with name of schema (SA in this case) and with the table name only (TB_LOCALIDADE)..doesn't work....
thnks, an sorry fo the poor English....
|
|
|
Re: SQL Loader [message #72569 is a reply to message #72568] |
Fri, 18 July 2003 13:15 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
-- did you miss the infile or loading data in the same control file or this a typo?
your code
[i]
LOAD DATA
APPEND
into table tb_localidade
fields terminated by ','
(IDT_LOCALIDADE,
NOM_LOCALIDADE,
DAT_ULT_ATUALIZACAO,
COD_USUARIO,
TIMESTAMP)
[/i]
----------------------------------------------------------------------
it should be something like
----------------------------------------------------------------------
LOAD DATA
infile 'somedatafile.txt'
APPEND
into table tb_localidade
fields terminated by ','
(IDT_LOCALIDADE,
NOM_LOCALIDADE,
DAT_ULT_ATUALIZACAO,
COD_USUARIO,
TIMESTAMP)
|
|
|