tablespace create for large volume image store
dear export,currently im configuring a oracle DB on ASM for store company customers image documents. file would be pdf,tif,jpeg,image,photos etc. there would be huge DB and not able have purge options for this db.
customer base is 9 miliion and each person have at least 5 type of images documents. 9million *5 =45million images. there is a growth of customer based day by day.
I have following quires.
1. what type of Table spaces should I create for this data to be stored. I hope to use BLOB data type. syntax preferred.
2. if I use compression for tables like deduplicate,compress,securefiles , does it gain real compression as images and PDF are already compressed.
customer base is 9 miliion and each person have at least 5 type of images documents. 9million *5 =45million images. there is a growth of customer based day by day.
I have following quires.
1. what type of Table spaces should I create for this data to be stored. I hope to use BLOB data type. syntax preferred.
2. if I use compression for tables like deduplicate,compress,securefiles , does it gain real compression as images and PDF are already compressed.
0