1.非partition表:
a.导出
userid=sajet/sajetdba@mesdbspc
buffer=8192
FILE=D:SPCbackupDataBackupg_spc_log0909.dmp
LOG=D:SPCbackupDataBackupg_spc_log0909exp.log
GRANTS=y
INDEXES=y
ROWS=y
CONSTRAINTS=y
TABLES=(g_spc_log)
QUERY="where update_time>=to_date('2000/09/01','yyyy/mm/dd')
and update_time<=to_date('2009/09/30','yyyy/mm/dd')"
b.导入
userid=sajet/tech@SPCHIS
buffer=8192
FILE=D:SPCbackupDataBackupg_spc_log0909.dmp
LOG=D:SPCbackupDataBackupg_spc_log0909imp.log
FROMUSER=SAJET
TOUSER=SAJET
IGNORE=y
c.删除
delete sajet.g_spc_log where update_time<=to_date('2009/09/30','yyyy/mm/dd');
2.partition表
a.导出
EXP.EXE SAJET/SAJETDBA@MESDBSPC FILE=F:SPCbackupPartitionEXPDATASPC201004.DMP BUFFER=65536000 TABLES=G_CUSTOMER_LOG:PART1004 ROWS=Y statistics=none LOG=F:SPCbackupPartitionEXPDATASPC201004exp.log
PAUSE
b.导入
IMP.EXE SAJET/tech@SPCHIS FILE=D:SPCbackupPartitionEXPDATASPC201003.DMP BUFFER=65536000 TABLES=G_CUSTOMER_LOG:PART1004 IGNORE=Y INDEXES=N STATISTICS=NONE LOG=D:SPCbackupPartitionEXPDATASPC201003imp.log
PAUSE
c.删除
ALTER TABLE SAJET.G_CUSTOMER_LOG DROP PARTITION PART1004;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23307206/viewspace-1037911/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23307206/viewspace-1037911/