Home » RDBMS Server » Server Administration » How to reduce storage of LOBs...?
How to reduce storage of LOBs...? [message #195015] Tue, 26 September 2006 09:28 Go to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
Hi ,

we have a 9i Prod database under Linux.
The application at the end user is storing the scanned LOB images into the database.
The scanned LOBs consume about 2MB for each records.

How can we reduce the storage of the scanned LOBs before storing into the database..?

Plz help being the space issue...


regards
bala
Re: How to reduce storage of LOBs...? [message #195029 is a reply to message #195015] Tue, 26 September 2006 12:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Compress them.
http://asktom.oracle.com/pls/ask/f?p=4950:8:11463438737389424285::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:12980645053487,
Re: How to reduce storage of LOBs...? [message #195038 is a reply to message #195015] Tue, 26 September 2006 13:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>How can we reduce the storage of the scanned LOBs before storing into the database
Obviously, in previous post i missed the point.
May i ask, why?
I still like database compression for the same reason stated by Tom in above URL.
Re: How to reduce storage of LOBs...? [message #195040 is a reply to message #195015] Tue, 26 September 2006 13:10 Go to previous messageGo to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
since it is space constraint , we need to reduce the storage of LOBs..
Re: How to reduce storage of LOBs...? [message #195041 is a reply to message #195040] Tue, 26 September 2006 13:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Question is, why would you like compress before storing into database instead of compressing inside the database?
Re: How to reduce storage of LOBs...? [message #195166 is a reply to message #195015] Wed, 27 September 2006 04:53 Go to previous messageGo to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
How can we compress the space inside the database...?
Plz guide...
Re: How to reduce storage of LOBs...? [message #195184 is a reply to message #195166] Wed, 27 September 2006 05:54 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you even bother to read the URL in my previous post?
OR
Should i copy the contents of the URL and post it here?
Previous Topic: SERVICE_NAMES in pfile
Next Topic: plz clear my doubts
Goto Forum:
  


Current Time: Sat Dec 10 06:49:26 CST 2016

Total time taken to generate the page: 0.19846 seconds