Storing Images on Oracel database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Storing Images on Oracel database

  1. #1
    Join Date
    Nov 2000
    Location
    London
    Posts
    83

    Talking

    Hi, I am trying to find out the method for storing images in Oracle database but I can't seem to find any documentations on it.

    I have tried Metalink but to no avail - if anyone can give me any help of info, please let me know!
    Share on Google+

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Use BLOB column for the image and store them externally to the database.
    Share on Google+

  3. #3
    Join Date
    Feb 2001
    Posts
    389
    Search for dbms_lob package , and also OCI with dbms_lob.
    Share on Google+

  4. #4
    Join Date
    Jan 2001
    Posts
    18
    Hi,

    You should use BLOB or BFILE datatype.
    If you need in a tool for loading imagies contact me at support@ispirer.com

    Best regards, Dmitry

    --
    [url]http://www.ispirer.com[/url] - Database migration tools and services for Oracle and IBM DB2.
    Share on Google+

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828

    Talking seeing is beleiving or is it pic is worth a 1000 words

    there are more than one way to store lob data

    a) you can use dbms_lob package
    b) you can use oci ( thsi is the fasyest way to load data)
    c) or you could use the good ol sql loadeer yeah you bet baby you can do it with sql loader heres an example of how i did it with my databse on linux 6.2 running oracle 8.1.6 r2 at my home. interested to know read on


    Using SQL*Loader to Load Rich Data

    SQL*Loader can load whole files into internal LOBs. For example, let's add one column called MY_RESUME to the recipes table.

    ALTER TABLE RESUMES
    ADD (MY_RESUME BLOB DEFAULT EMPTY_BLOB());

    The MY_RESUME column will hold Adobe Acrobat PDF files that contain the most recent update of my resume. You can bulk load existing resumes into the database with SQL*Loader. In this example, a file named resumess.dat, containing data targeted for insertion into the RESUMES table.

    1,HRISHI' s resume
    ,/u12/oracle/admin/dev/dishimages/1.pdf,
    2,Fiona ,/u12/oracle/admin/dev/dishimages/2.pdf,

    When loading the data, you use a SQL*Loader control file similar to this example:


    LOAD DATA
    INFILE 'resumes.dat'
    APPEND INTO TABLE RESUMES
    FIELDS TERMINATED BY ','
    (name, external_filename FILLER,
    resumes LOBFILE(external_filename)
    TERMINATED BY EOF
    )

    enjoy
    :-)



    Share on Google+

  6. #6
    Join Date
    Nov 2000
    Location
    London
    Posts
    83
    Thank you all for your reply and help! Much appreciated! >o<
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width