Trying to store files in Oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Trying to store files in Oracle

  1. #1
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,021

    Question Trying to store files in Oracle

    We have an OLTP application written in Power Builder v8. We are going to be storing files in the database with Power Builder. We currently use the LONG data type for storing data windows. What is the best datatype for storing files. They could be anything from word docs, to jpg files. Which is a better datatype for storing files LONG or BLOB? and what are the relative merits of each? Thanks in advance.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    No question - use BLOB. The reasons are discussed here in the documentation
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    BLOB........of course. Why otherwise Oracle would introduce this new feature????
    Agasimani
    OCP(10g/9i/8i/8)

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,021
    Thanks for the input. I am going to recommend that we use blobs.

  5. #5
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    You have a choice of BLOBS or BFILES. BFILES are stored as OS files accessed by database through directory objects. If the files are big and are not updated (read only) you can use BFILES.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  6. #6
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,021
    Originally posted by kris109
    You have a choice of BLOBS or BFILES. BFILES are stored as OS files accessed by database through directory objects. If the files are big and are not updated (read only) you can use BFILES.
    Thanks for the suggestion.

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