Oracle Tablespace之间数据迁移
分区表常用的数据字典

分区表信息: dba_part_tables
显示分区: dba_tab_partitions
显示子分区: dba_tab_subpartitions
显示分区列: dba_part_key_columns
显示子分区列:dba_subpart_dey_columns
显示分区索引:dba_part_indexes
显示索引分区:dba_ind_partitions

 alter table KNOWLEDGEITEM move lob(KILOCALTEXT)  store as (tablespace  WZRQ);  alter table MAIL_JOB move lob(MAIL_CONTENT)  store as (tablespace  WZRQ);    alter table FAX_JOB move lob(FAX_CONTENT)  store as (tablespace  WZRQ);

参考资料
http://blog.sina.com.cn/s/blog_713bf4fe01011cyu.html
http://xsb.itpub.net/post/419/38506