Á¦ ¸ñ: (8i~) PARTITION TABLEÀÇ °ü¸®(add, drop, ³ª´©±â) - 1
³» ¿ë
1. partition tableÀÇ Á¤º¸ È®ÀÎ
¨ç SELECT TABLE_NAME, PARTITION_NAME, PARTITION_POSITION, HIGH_VLAUE
FROM DBA_TAB_PARTITIONS;
----------------------
(ALL_TAB_PARTITIONS, USER_TAB_PARTITIONS)
¨è SELECT * FROM partiton_table PARTITION partition_name_?
2. partition tableÀÇ add
ALTER TABLE partition_table ADD PARTITION partition_name_?
VALESS LESS THAN ( °ª )
[TABLESPACE tablespac_name]
3. partition tableÀÇ drop
ALTER TABLE partition_table DROP PARTITION partition_name_?
4. partition table ³ª´©±â
- ±âÁ¸ÀÇ partition¿¡¼ split Çؼ »ðÀÔÇÑ´Ù.
ALTER TABLE partition_table SPLIT PARTITION partiton_name_?
AT ( range )
INTO ( PARTITION partition_name_? ,
PARTITION partition_name_? )
Á¦ ¸ñ: (8i~) PARTITION TABLEÀÇ °ü¸®(nameº¯°æ, move, truncate, ¼Ó¼ºº¯°æ, index rebuild) - 2
³» ¿ë
1. Partition name º¯°æ
SQL> ALTER TABLE partition_table RENAME PARTITION old_partition_name_? TO new_partition_name_?
2. Partition tableÀ» ´Ù¸¥ Tablespace·Î À̵¿(move)
SQL> ALTER TABLE partition_table MOVE PARTITION partition_name_? TABLESPACE tablespace_name
3. PartitionÀÇ data¸¦ truncate
- partitionÀÇ data¸¦ ¸ðµÎ »èÁ¦ÇÑ´Ù.
SQL> ALTER TABLE partition_table TRUNCATE PARTITION test_p2
4. Partition tableÀÇ ¹°¸®ÀûÀÎ ¼Ó¼º º¯°æ
¨ç Àüü partitionÀÇ µ¿ÀÏÇÑ ¼Ó¼º º¯°æ
SQL> ALTER TABLE partition_table STORAGE( MAXEXTENTS ??? )
¨è ƯÁ¤ partitionÀÇ ¼Ó¼º¸¸ º¯°æ
ALTER TABLE partition_table MODIFY PARTITION partition_name_? STORAGE( MAXEXTENTS ???)
5. Partition Index rebuild
- À§¿Í °°Àº partition ÀÛ¾÷À» ÇÑ ÈÄ¿¡´Â index¸¦ rebuildÇØ ÁØ´Ù.
¨ç partitionÀÇ index rebuild
SQL> ALTER INDEX index_name REBUILD PARTITION index_partition_name
|
|
|