Database Software

hi export, I need to used advance compression option. I have planed to store 2T size images in oracle DB and need to improve faster query.

I used systax this way (sample table):

SQL> CREATE TABLE cus_sig
2 (MOBILE_NO varchar2(50),
3 IMAGE_NAME varchar2(50),
4 IMAGE BLOB)
5 LOB(IMAGE) STORE AS SECUREFILE (
6 COMPRESS HIGH
7 CACHE
8 );


1. pl confirm when Im going to store data in this does it compress?

2 when i check the user_tables option , compression is disabled.

SQL> select table_name, compression, compress_for from user_tables where table_name in ('CUS_SIG');
TABLE_NAME COMPRESS COMPRESS_FOR
------------------------------ -------- ------------
CUS_SIG DISABLED

then how to enable this option ...what is the correct way i should use it


waiting for response..

Thanks

ashwan