Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

compress blob column to save space on server

dbapeDec 28 2015 — edited Jan 25 2016

Hi Friends,

I have an issue with blob column, in oracle database 11.2.0.4 on aix server

I have a table with a column blob (which contain jpg file). This table is in a tablespace of 300 gb, and the tablespace is full. There is no space in the server (asm).

I need to load more jpg into this table, but it does not have space.

I read some articles about compress tha blob column, but I dont sure what I should do.

Is there any way to compress the blob column without move to another tablespace (because the server does not have more space to create another).

The table and the column were created in traditional way.

Please, Any advice?

Best Regards,

Dbape.

This post has been answered by Mike Kutz on Dec 29 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2016
Added on Dec 28 2015
8 comments
1,707 views