Database DataWarehousing (MOSC)

MOSC Banner

tablespace create for large volume image store

edited Jan 3, 2012 2:03AM in Database DataWarehousing (MOSC) 5 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center