Hello everybody. this is my first post in this forum.
Actually i am looking for how to store binary files (like music files, doc files) inside Oracle database, specifically Oracle 10G.
If they are not physically stored, how references are made to those files?
How online music store tackles the situation with huge no. of files?
At least in my experience, storing BLOBs within a database has been a poor choice. The performance impact on the end user is usually significant, if not enough to be a "deal breaker" because database engines don't often handle BLOB transfers very well.
I've had much better luck storing a reference to the BLOB, such as a URL or UNC pathname. This allows your code to use tools built for the job such as FTP to move data wholesale from one box (a server) to another (client). This also allows you to use a "divide and conquer" approach as your needs grow, so that you can have the files served up by another machine(s) when your database becomes too busy to do the job.
How about a BIT table which holds the position and value (0 or 1) of each bit in the BLOB.... then write a program to reconstruct the binary from the query result. Of course, you will have to have a foreign key referencing a bit lookup table in order to enforce the ones and zeroes. (In case you ever want to move to ternary digits and an associated acronym)