advance compression how to used
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
------------------------------ -------- ------------