Home » Developer & Programmer » Data Integration » working with external tables
working with external tables [message #153447] Mon, 02 January 2006 08:07 Go to next message
samar@infoprise
Messages: 4
Registered: January 2006
Location: lebanon
Junior Member

i am trying to use external tables in ETL. The external table is linked correctly to a flat file and all the locations are set correctly, but when trying to view the data in the external table using sql plus, toad, or enterprise manager a problem appears and no data is found.
the error is :
"
ERROR AT LINE 1:
ORA-29913: error in executing ODCIEECTTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file tbcall.csv n target_location_ff_location not found
ORA-06512: at "sys.oracle_loader", line 14
ORA-06512: at line 1
"

WAITING FOR YOUR REPLY.
THANKS.
Re: working with external tables [message #153654 is a reply to message #153447] Tue, 03 January 2006 09:54 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Have you registered the location?

MHE
Previous Topic: Informatica
Next Topic: Can I use database 10g with express ?
Goto Forum:
  


Current Time: Thu Mar 28 06:51:34 CDT 2024