목록partition exchange (1)

소소한 일상에서 책읽기 중

Partition Table의 Index Compress 하기

1. create Partitioned Table and create Local Index noncompress SQL> conn eun/loveora77 Connected. SQL> rem create Partitioned Table and create Local Index noncompress SQL> CREATE TABLE eun.HE_EMP_TEST1 SQL> TABLESPACE SS_DB_DATA3 SQL> NOLOGGING SQL> COMPRESS FOR QUERY HIGH SQL> PARTITION BY RANGE(LD_OP_DTM) SQL> ( SQL> PARTITION PT_2011053112 VALUES LESS THAN ('20110531130000') SQL> ) SQL> as SQ..
DB까다롭다 2011. 6. 1. 17:57
이전 Prev 1 Next 다음