Home » SQL & PL/SQL » SQL & PL/SQL » How does one use SQL*Loader to load images
How does one use SQL*Loader to load images [message #208556] Mon, 11 December 2006 05:42 Go to next message
oracle_doubts
Messages: 6
Registered: March 2006
Junior Member
Wishes to Everybody,

I have an issue on How does one use SQL*Loader to load images.My table structure is given below.

CREATE TABLE image_table (
image_id NUMBER(5),
image_data LONG RAW);

Desperately posted this query.

Regards
Gopinath
Re: How does one use SQL*Loader to load images [message #208558 is a reply to message #208556] Mon, 11 December 2006 05:52 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Have a look here
http://www.oracle-base.com/articles/8i/ImportBlob.php

and here for
sql loader
http://www.dba-oracle.com/oracle_news/2005_5_11_easy_top_loading_images_tables.htm

[Updated on: Mon, 11 December 2006 05:54]

Report message to a moderator

Re: How does one use SQL*Loader to load images [message #208576 is a reply to message #208558] Mon, 11 December 2006 07:21 Go to previous messageGo to next message
oracle_doubts
Messages: 6
Registered: March 2006
Junior Member
Hi tahpush,

Thank you for your reply.But still the I did not get the resolution for my issues.

I have gone through two URL's you gave to me.In both the links they have tables with BLOB as datatype to the column, to which the image has to be uploaded.But in my table I have LONG RAW as datatype.I am just looking for images to upload into this long raw data type column.

If you have any more information on this can you please share with me

Regards
Gopinath
Re: How does one use SQL*Loader to load images [message #208589 is a reply to message #208556] Mon, 11 December 2006 07:53 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Hi

Uhh seems like a pain but here's a very good refernce for that purpose
http://www.tilsor.com.uy/servicios/soporte_tecnico/documentos/fichas/3.htm

Hope it helps
icon7.gif  Re: How does one use SQL*Loader to load images [message #208898 is a reply to message #208589] Tue, 12 December 2006 08:32 Go to previous messageGo to next message
oracle_doubts
Messages: 6
Registered: March 2006
Junior Member
Applauds Laughing ,The URL you gave resolved all my issues and helped me a lot.I was struggling for this from 2 months.Ultimately solved by tahpush.

Thanks a lot tahpush

Cheers
Gopinath
Re: How does one use SQL*Loader to load images [message #208904 is a reply to message #208898] Tue, 12 December 2006 09:04 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
oracle_doubts wrote on Tue, 12 December 2006 15:32
Applauds Laughing ,The URL you gave resolved all my issues and helped me a lot.
Of course it did, it's a copy/paste from MetaLink Note: 96961.1.
oracle_doubts wrote on Tue, 12 December 2006 15:32
Ultimately solved by tahpush.
That would be Oracle Corp. Wink And that site from Urugay (?) is disclosing copyrighted information from the Oracle support website.

MHE

[Updated on: Tue, 12 December 2006 09:04]

Report message to a moderator

Re: How does one use SQL*Loader to load images [message #208917 is a reply to message #208904] Tue, 12 December 2006 10:01 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

He's satisfied and happy , that's good enough for me Smile
icon14.gif  Re: How does one use SQL*Loader to load images [message #209019 is a reply to message #208917] Tue, 12 December 2006 23:37 Go to previous message
oracle_doubts
Messages: 6
Registered: March 2006
Junior Member
Thank you tahpush
Previous Topic: an problem in TKPROF
Next Topic: Format SQL-output (merged)
Goto Forum:
  


Current Time: Sat Dec 03 08:24:03 CST 2016

Total time taken to generate the page: 0.07818 seconds