Hi there.
I'm pretty new to Oracle so plz no flames :)
I have many small files measuring btw 200kb - 500 kb each.
I expect them to grow to about 20-30 gig a year in total.
I intend to insert them as a glob/binary into the Oracle db.
Putting them into directories and then linking/refrencing to them is out 'cos of the complexity of
the database design and the flexibility that is needed in the future to move the files from record
to record.
- Can Oracle handle this? I means in terms of speed & record searches & file retrievals?
- Won't it slow down with such a huge load of binary data?
- Will it get easily corrupted?
I know that MySQL treats each created table as a physical file in the /mysql directory.
This is for the unix/linux version. Not sure of the M$ version.
If I lump all the globs/files into one table, the particular MySQL table file is going to be very
big. This makes backups hard too.
4. Does Oracle also treat each table as a physical file in it's directory?
How does Oracle handle it's data "behind"?
