OraFAQ Forum: Server Administration » How to reduce storage of LOBs...?

Home » RDBMS Server » Server Administration » How to reduce storage of LOBs...?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to reduce storage of LOBs...? [message #195015]

Tue, 26 September 2006 09:28

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

Report message to a moderator

Re: How to reduce storage of LOBs...? [message #195029 is a reply to message #195015]

Tue, 26 September 2006 12:08

Mahesh Rajendran
Messages: 10707
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,

Report message to a moderator

Re: How to reduce storage of LOBs...? [message #195038 is a reply to message #195015]

Tue, 26 September 2006 13:05

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: How to reduce storage of LOBs...? [message #195040 is a reply to message #195015]

Tue, 26 September 2006 13:10

balavignesh
Messages: 180
Registered: March 2005

Senior Member

since it is space constraint , we need to reduce the storage of LOBs..

Report message to a moderator

Re: How to reduce storage of LOBs...? [message #195041 is a reply to message #195040]

Tue, 26 September 2006 13:36

Mahesh Rajendran
Messages: 10707
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?

Report message to a moderator

Re: How to reduce storage of LOBs...? [message #195166 is a reply to message #195015]

Wed, 27 September 2006 04:53

balavignesh
Messages: 180
Registered: March 2005

Senior Member

How can we compress the space inside the database...?
Plz guide...

Report message to a moderator

Re: How to reduce storage of LOBs...? [message #195184 is a reply to message #195166]

Wed, 27 September 2006 05:54

Mahesh Rajendran
Messages: 10707
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?

Report message to a moderator

Previous Topic:	SERVICE_NAMES in pfile
Next Topic:	plz clear my doubts

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:38:52 CDT 2024