1.导出整个分区表

        exp asi/asi@asires tables=res_pnr_seg_his file=F: mp_db_N2006Q2.dmp

2.导出单个分区

        exp asi/asi@asires tables=res_pnr_seg_his:PART_2006_2 file=F: mp_db_N2006Q2.dmp

如果要导出多个分区，则在tables参数中增加分区数。如：tables= (res_pnr_seg_his:PART_2006Q2,res_pnr_seg_his:PART_2006Q2)

3.导入单个分区(使用先前备份的单个分区导入文件)

imp scott/tiger tables=res_pnr_seg_his:PART_2006_2 file=F: mp_db_N2006Q2.dmp ignore=y

4.导入整个表

imp scott/tiger tables=res_pnr_seg_his file=F: mp_db_N2006Q2.dmp ignore=y indexes=y