怎么在线对表进行分区（How to perform online redefinition）(三)
INDEX_NAME INDEX_TYPE TABLE_NAME
------------------------------ --------------------------- --------------------------------------------------
PRIMARY_KEY_ID NORMAL AMY
SQL>
后续操作：
SQL> select table_name,column_name,data_type from user_tab_cols where table_name='AMY';
TABLE_NAME COLUMN_NAME DATA_TYPE
-------------------------------------------------- ------------------------------ ------------------------------------------------------------
AMY ID NUMBER
AMY CREATE_DATE TIMESTAMP(6)
AMY SYS_C00003_13101717:32:40$ VARCHAR2
SQL> ALTER TABLE AMY DROP UNUSED COLUMNS;
Table altered.
SQL> drop table amy_temp purge;
Table dropped.
SQL>
SQL> select table_name,partition_name,high_value from user_tab_partitions where table_name='AMY';
TABLE_NAME PARTITION_NAME HIGH_VALUE
---------- -------------------- ----------------------------------------------------------------------------------------------------
AMY PART200000 200000
AMY PART500000 500000
AMY PART_OTHER MAXVALUE
SQL>
删除这个表中小于200000的数据。
eg：
SQL>
SQL> select * from (select * from amy order by id) where rownum<10;
ID CREATE_DATE
---------- ---------------------------------------------------------------------------
200000 17-OCT-13 03.45.38.985089 PM
200001 17-OCT-13 03.45.38.985201 PM
200002 17-OCT-13 03.45.38.985320 PM
200003 17-OCT-13 03.45.38.985422 PM
200004 17-OCT-13 03.45.38.985538 PM
200005 17-OCT-13 03.45.38.986409 PM
200006 17-OCT-13 03.45.38.986626 PM
200007 17-OCT-13 03.45.38.986729 PM
200008 17-OCT-13 03.45.38.986836 PM
9 rows selected.