Database Administration (MOSC)

MOSC Banner

advance compression how to used

edited Jan 11, 2011 1:49AM in Database Administration (MOSC) 8 commentsAnswered
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
------------------------------ -------- ------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center