OTN Discussion Forums : Error while loading table from flat ...

This question is answered. Helpful answers available: 4. Correct answers available: 1.

Reply to this Thread

Search Forum

Back to Thread List

Replies: 7 - Pages: 1 - Last Post: May 26, 2009 11:01 PM Last Post By: ashoka_bl

ashoka_bl

Posts: 7
Registered: 05/26/09

Error while loading table from flat file (.csv)
Posted: May 26, 2009 4:35 AM

I have a flat file which i am loading into a Target Table in Oracle Warehouse Builder. It uses SQL Loader Internally to load the data from flat file, I am facing an issue. Please find the following error ( This is an extract from the error log generated)

****************************************************************************************************************
SQL*Loader-500: Unable to open file (D:\MY CURRENT PROJECTS\GEIP-IHSS-Santa Clara\CDI-OWB\Source_Systems\Acquisition.csv)
SQL*Loader-552: insufficient privilege to open file
SQL*Loader-509: System error: The data is invalid.
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
****************************************************************************************************************

I believe that this is related to SQL * Loader error.

ACtually the flat file resides in my system ( D:\MY CURRENT PROJECTS\GEIP-IHSS-Santa Clara\CDI-OWB\Source_Systems\Acquisition.csv). I am connecting to a oracle server.

Please suggest

Is it required that i need to place the flat file in Oracle Server System ??

Regards,
Ashoka BL

Nawneet

Posts: 674
Registered: 02/02/09

Re: Error while loading table from flat file (.csv)
Posted: May 26, 2009 4:57 AM

in response to: ashoka_bl

place the file in Oracle server and also check the priviledge.
You should be able to read the file.
and write access on Folder.

ashoka_bl

Posts: 7
Registered: 05/26/09

Re: Error while loading table from flat file (.csv)
Posted: May 26, 2009 5:04 AM

in response to: Nawneet

Hi Nawneet,

Thanks for the reply. Is it mandatory to put the file in the oracle server ?

Regards,
Ashoka BL

Nawneet

Posts: 674
Registered: 02/02/09

Re: Error while loading table from flat file (.csv)
Posted: May 26, 2009 5:06 AM

in response to: ashoka_bl

Helpful

According to my experience Yes ,If you want to execute it from OWB.

ashoka_bl

Posts: 7
Registered: 05/26/09

Re: Error while loading table from flat file (.csv)
Posted: May 26, 2009 5:10 AM

in response to: Nawneet

Thank you very much, i will put the files in Server and if i face any issues, i will get back.

ashoka_bl

Posts: 7
Registered: 05/26/09

Re: Error while loading table from flat file (.csv)
Posted: May 26, 2009 10:21 PM

in response to: ashoka_bl

Hi,

Can i import a File in OWB from a remote location, Actually i have placed all the .CSV files in my oracle server. Can i provide a path like "\\172.23.68.10\Users\Test\Ecommerce.csv", to import the file.

Or else i need to go and create a Location and import files in Oracle Server system only.

Regards,
Ashoka BL

Nawneet

Posts: 674
Registered: 02/02/09

Re: Error while loading table from flat file (.csv)
Posted: May 26, 2009 10:54 PM

in response to: ashoka_bl

Can i import a File in OWB from a remote location, Actually i have placed all the .CSV files in my oracle server. Can i provide a path like "\\172.23.68.10\Users\Test\Ecommerce.csv", to import the file.

you cannot give path from client OWB to remote location.

you can connect to Server OWB and then import the file .

ashoka_bl

Posts: 7
Registered: 05/26/09

Re: Error while loading table from flat file (.csv)
Posted: May 26, 2009 11:01 PM

in response to: Nawneet

Hi Nawneet,

I just created a Location in OWB using the Server Path, and imported the files from the same location. I did the mapping and I am able to load the Target Table.

I have created Location using the path : \\172.23.68.10\Users\Test ( I have placed all my .CSV files there)

I Imported the files, and its working fine for me

Thanks for the suggestions

Regards,
Ashoka BL

Pages: 1

Back to Thread List

Legend
	Guru : 2500 - 1000000 pts
	Expert : 1000 - 2499 pts
	Pro : 500 - 999 pts
	Journeyman : 200 - 499 pts
	Newbie : 0 - 199 pts
	Oracle ACE Director
	Oracle ACE Member
	Oracle Employee ACE
	Helpful Answer (5 pts)
	Correct Answer (10 pts)