0

hello everyone...
could anyone tell me how to store images in oracle database..or which datatype has to use for it..

8
Contributors
14
Replies
16
Views
6 Years
Discussion Span
Last Post by saideepak89
Featured Replies
  • 2

    Personnally, I prefer to leave images on the network file server, than to store them in the database. However, being a consultant, I pretty well have to do what my clients want. Read More

  • 1
    jbennet 1,618   6 Years Ago

    Storing images themselves in a database sounds like a really bad idea, just store the server path. Read More

2

Personnally, I prefer to leave images on the network file server, than to store them in the database.
However, being a consultant, I pretty well have to do what my clients want.

Votes + Comments
agree
1

Is it really necessary to store the images in the database? Like debasisdas pointed out, you can store the image as binary.
Maybe it's a good idea to store the images on the server and just make a reference to it's directory on the database.

1

Storing images themselves in a database sounds like a really bad idea, just store the server path.

0

thanks a lot, but can u please tel hw to store server path in the database..
means is there any technique to convert?

0

No need to convert anything.

1. Create a directory in the server.
2. Create an Oracle directory for the server directory.
3. Store all the files in the server directory.
4. In the database store the file path as string and also the Oracle directory name.

0

Technically, you don't have to store anything in the DB.
Put all of you images in one location on the network.
eg. /Production/My_System/Images
Name your image file with the record PK.
eg. 0123456.jpg
If there is ever a breach in security,
people's names are NOT show with the image.

0

hello everyone...
could anyone tell me how to store images in oracle database..or which datatype has to use for it..

Hi you can store images in oracle by using datatype as Bfile. it has a capacity of 4 gb of filesize. Bfile stores Binary data of external file upto 4 gb.

Hope this helps.

0

Using bfile is same as storing the path of the file in disc.

In this approach the problem is if the file is deleted or moved out of the specified oracle directory oracle will will be unable to retrieve the file and will throw an error.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.