Chinaunix首页 | 论坛 | 博客
  • 博客访问: 3241802
  • 博文数量: 949
  • 博客积分: 10126
  • 博客等级: 上将
  • 技术积分: 12100
  • 用 户 组: 普通用户
  • 注册时间: 2006-06-16 10:57
文章分类

全部博文(949)

文章存档

2013年(1)

2012年(4)

2011年(4)

2010年(12)

2009年(342)

2008年(586)

分类:

2009-02-26 23:17:54


越来越佩服自己的效率了,说明了要5个工作日的,对38张重要数据表新建分区表,并备份和清理部分0506年的数据,4个小时搞定,明天把善后作了.

20090226
1、目录变动通知    DX_T_BDTZ
RENAME DX_T_BDTZ TO DX_T_BDTZ_BAK;
create table DX_T_BDTZ PARTITION BY RANGE (C_CZNF)
(
PARTITION DX_T_BDTZ_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION DX_T_BDTZ_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION DX_T_BDTZ_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION DX_T_BDTZ_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION DX_T_BDTZ_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION DX_T_BDTZ_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION DX_T_BDTZ_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION DX_T_BDTZ_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION DX_T_BDTZ_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION DX_T_BDTZ_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION DX_T_BDTZ_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM DX_T_BDTZ_BAK;

DROP TABLE DX_T_BDTZ_BAK;


rm /tmp/pipo_DX_T_BDTZ_2006
mknod /tmp/pipo_DX_T_BDTZ_2006 p
compress DX_T_BDTZ_2006.dmp.Z & exp zjda/password file=/tmp/pipo_DX_T_BDTZ_2006 tables=DX_T_BDTZ:DX_T_BDTZ_2006
rm /tmp/pipo_DX_T_BDTZ_2006


Export: Release 9.2.0.6.0 - Production on Thu Feb 26 17:42:09 2009

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Export done in ZHS16CGB231280 character set and UTF8 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                      DX_T_BDTZ
. . exporting partition                 DX_T_BDTZ_2006          0 rows exported
Export terminated successfully without warnings.





2 报刊出版情况表    DX_T_BKCBQKB

RENAME DX_T_BKCBQKB TO DX_T_BKCBQKB_BAK;
create table DX_T_BKCBQKB PARTITION BY RANGE (C_CZNF)
(
PARTITION DX_T_BKCBQKB_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION DX_T_BKCBQKB_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION DX_T_BKCBQKB_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION DX_T_BKCBQKB_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION DX_T_BKCBQKB_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION DX_T_BKCBQKB_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION DX_T_BKCBQKB_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION DX_T_BKCBQKB_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION DX_T_BKCBQKB_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION DX_T_BKCBQKB_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION DX_T_BKCBQKB_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM DX_T_BKCBQKB_BAK;

DROP TABLE DX_T_BKCBQKB_BAK;


rm /tmp/pipo_DX_T_BKCBQKB_2006
mknod /tmp/pipo_DX_T_BKCBQKB_2006 p
compress DX_T_BKCBQKB_2006.dmp.Z &
exp zjda/password file=/tmp/pipo_DX_T_BKCBQKB_2006 tables=DX_T_BKCBQKB:DX_T_BKCBQKB_2006
rm /tmp/pipo_DX_T_BKCBQKB_2006





3 报刊目录    DX_T_BKML
RENAME DX_T_BKML TO DX_T_BKML_BAK;
create table DX_T_BKML PARTITION BY RANGE (C_CZNF)
(
PARTITION DX_T_BKML_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION DX_T_BKML_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION DX_T_BKML_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION DX_T_BKML_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION DX_T_BKML_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION DX_T_BKML_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION DX_T_BKML_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION DX_T_BKML_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION DX_T_BKML_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION DX_T_BKML_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION DX_T_BKML_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM DX_T_BKML_BAK;

DROP TABLE DX_T_BKML_BAK;




rm /tmp/pipo_DX_T_BKML_2006
mknod /tmp/pipo_DX_T_BKML_2006 p
compress DX_T_BKML_2006.dmp.Z &
exp zjda/password file=/tmp/pipo_DX_T_BKML_2006 tables=DX_T_BKML:DX_T_BKML_2006
rm /tmp/pipo_DX_T_BKML_2006

alter table DX_T_BKML drop PARTITION DX_T_BKML_2006;

4报刊特价表 DX_T_BKTJB
RENAME DX_T_BKTJB TO DX_T_BKTJB_BAK;
create table DX_T_BKTJB PARTITION BY RANGE (C_CZNF)
(
PARTITION DX_T_BKTJB_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION DX_T_BKTJB_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION DX_T_BKTJB_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION DX_T_BKTJB_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION DX_T_BKTJB_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION DX_T_BKTJB_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION DX_T_BKTJB_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION DX_T_BKTJB_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION DX_T_BKTJB_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION DX_T_BKTJB_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION DX_T_BKTJB_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM DX_T_BKTJB_BAK;

DROP TABLE DX_T_BKTJB_BAK;



rm /tmp/pipo_DX_T_BKTJB_2006
mknod /tmp/pipo_DX_T_BKTJB_2006 p
compress DX_T_BKTJB_2006.dmp.Z &
exp zjda/password file=/tmp/pipo_DX_T_BKTJB_2006 tables=DX_T_BKTJB:DX_T_BKTJB_2006
rm /tmp/pipo_DX_T_BKTJB_2006


5 发行范围表    DX_T_FXFWB
RENAME DX_T_FXFWB TO DX_T_FXFWB_BAK;
create table DX_T_FXFWB PARTITION BY RANGE (C_CZNF)
(
PARTITION DX_T_FXFWB_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION DX_T_FXFWB_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION DX_T_FXFWB_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION DX_T_FXFWB_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION DX_T_FXFWB_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION DX_T_FXFWB_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION DX_T_FXFWB_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION DX_T_FXFWB_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION DX_T_FXFWB_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION DX_T_FXFWB_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION DX_T_FXFWB_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM DX_T_FXFWB_BAK;

DROP TABLE DX_T_FXFWB_BAK;


rm /tmp/pipo_DX_T_FXFWB_2006
mknod /tmp/pipo_DX_T_FXFWB_2006 p
compress DX_T_FXFWB_2006.dmp.Z &
exp zjda/password file=/tmp/pipo_DX_T_FXFWB_2006 tables=DX_T_FXFWB:DX_T_FXFWB_2006
rm /tmp/pipo_DX_T_FXFWB_2006




6 合休刊表    DX_T_HXKB
RENAME DX_T_HXKB TO DX_T_HXKB_BAK;
create table DX_T_HXKB PARTITION BY RANGE (C_CZNF)
(
PARTITION DX_T_HXKB_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION DX_T_HXKB_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION DX_T_HXKB_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION DX_T_HXKB_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION DX_T_HXKB_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION DX_T_HXKB_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION DX_T_HXKB_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION DX_T_HXKB_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION DX_T_HXKB_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION DX_T_HXKB_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION DX_T_HXKB_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM DX_T_HXKB_BAK;

DROP TABLE DX_T_HXKB_BAK;




rm /tmp/pipo_DX_T_HXKB_2006
mknod /tmp/pipo_DX_T_HXKB_2006 p
compress DX_T_HXKB_2006.dmp.Z &
exp zjda/password file=/tmp/pipo_DX_T_HXKB_2006 tables=DX_T_HXKB:DX_T_HXKB_2006
rm /tmp/pipo_DX_T_HXKB_2006




alter table DX_T_HXKB drop PARTITION DX_T_HXKB_2006;


7    增减版表    DX_T_ZJBB
RENAME DX_T_ZJBB TO DX_T_ZJBB_BAK;
create table DX_T_ZJBB PARTITION BY RANGE (C_CZNF)
(
PARTITION DX_T_ZJBB_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION DX_T_ZJBB_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION DX_T_ZJBB_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION DX_T_ZJBB_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION DX_T_ZJBB_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION DX_T_ZJBB_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION DX_T_ZJBB_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION DX_T_ZJBB_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION DX_T_ZJBB_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION DX_T_ZJBB_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION DX_T_ZJBB_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM DX_T_ZJBB_BAK;

DROP TABLE DX_T_ZJBB_BAK;


rm /tmp/pipo_DX_T_ZJBB_2006
mknod /tmp/pipo_DX_T_ZJBB_2006 p
compress DX_T_ZJBB_2006.dmp.Z & exp zjda/password file=/tmp/pipo_DX_T_ZJBB_2006 tables=DX_T_ZJBB:DX_T_ZJBB_2006
rm /tmp/pipo_DX_T_ZJBB_2006

alter table DX_T_ZJBB drop PARTITION DX_T_ZJBB_2006;


8    补退款记录表    SD_T_BTKJLB

RENAME SD_T_BTKJLB TO SD_T_BTKJLB_BAK;
create table SD_T_BTKJLB PARTITION BY RANGE (C_CZNF)
(
PARTITION SD_T_BTKJLB_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION SD_T_BTKJLB_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION SD_T_BTKJLB_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION SD_T_BTKJLB_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION SD_T_BTKJLB_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION SD_T_BTKJLB_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION SD_T_BTKJLB_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION SD_T_BTKJLB_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION SD_T_BTKJLB_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION SD_T_BTKJLB_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION SD_T_BTKJLB_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM SD_T_BTKJLB_BAK;

DROP TABLE SD_T_BTKJLB_BAK;




9    订户基本资料    SD_T_DHJBZL

RENAME SD_T_DHJBZL TO SD_T_DHJBZL_BAK;
create table SD_T_DHJBZL PARTITION BY RANGE (C_CZNF)
(
PARTITION SD_T_DHJBZL_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION SD_T_DHJBZL_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION SD_T_DHJBZL_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION SD_T_DHJBZL_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION SD_T_DHJBZL_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION SD_T_DHJBZL_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION SD_T_DHJBZL_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION SD_T_DHJBZL_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION SD_T_DHJBZL_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION SD_T_DHJBZL_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION SD_T_DHJBZL_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM SD_T_DHJBZL_BAK;

DROP TABLE SD_T_DHJBZL_BAK;


10    改退记录表    SD_T_GTJLB

RENAME SD_T_GTJLB TO SD_T_GTJLB_BAK;
create table SD_T_GTJLB PARTITION BY RANGE (C_CZNF)
(
PARTITION SD_T_GTJLB_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION SD_T_GTJLB_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION SD_T_GTJLB_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION SD_T_GTJLB_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION SD_T_GTJLB_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION SD_T_GTJLB_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION SD_T_GTJLB_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION SD_T_GTJLB_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION SD_T_GTJLB_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION SD_T_GTJLB_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION SD_T_GTJLB_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM SD_T_GTJLB_BAK;

DROP TABLE SD_T_GTJLB_BAK;



11    缴款汇总表    SD_T_JKHZB

RENAME SD_T_JKHZB TO SD_T_JKHZB_BAK;
create table SD_T_JKHZB PARTITION BY RANGE (C_CZNF)
(
PARTITION SD_T_JKHZB_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION SD_T_JKHZB_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION SD_T_JKHZB_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION SD_T_JKHZB_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION SD_T_JKHZB_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION SD_T_JKHZB_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION SD_T_JKHZB_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION SD_T_JKHZB_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION SD_T_JKHZB_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION SD_T_JKHZB_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION SD_T_JKHZB_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM SD_T_JKHZB_BAK;

DROP TABLE SD_T_JKHZB_BAK;


12    缴款记录表    SD_T_JKJLB

RENAME SD_T_JKJLB TO SD_T_JKJLB_BAK;
create table SD_T_JKJLB PARTITION BY RANGE (C_CZNF)
(
PARTITION SD_T_JKJLB_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION SD_T_JKJLB_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION SD_T_JKJLB_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION SD_T_JKJLB_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION SD_T_JKJLB_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION SD_T_JKJLB_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION SD_T_JKJLB_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION SD_T_JKJLB_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION SD_T_JKJLB_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION SD_T_JKJLB_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION SD_T_JKJLB_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM SD_T_JKJLB_BAK;

DROP TABLE SD_T_JKJLB_BAK;


13    收订记录表    SD_T_SDJLB

RENAME SD_T_SDJLB TO SD_T_SDJLB_BAK;
create table SD_T_SDJLB PARTITION BY RANGE (C_CZNF)
(
PARTITION SD_T_SDJLB_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION SD_T_SDJLB_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION SD_T_SDJLB_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION SD_T_SDJLB_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION SD_T_SDJLB_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION SD_T_SDJLB_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION SD_T_SDJLB_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION SD_T_SDJLB_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION SD_T_SDJLB_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION SD_T_SDJLB_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION SD_T_SDJLB_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM SD_T_SDJLB_BAK;

DROP TABLE SD_T_SDJLB_BAK;



14    短缺订户表    TD_T_DQDH
RENAME TD_T_DQDH TO TD_T_DQDH_BAK;
create table TD_T_DQDH PARTITION BY RANGE (C_CZNF)
(
PARTITION TD_T_DQDH_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION TD_T_DQDH_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION TD_T_DQDH_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION TD_T_DQDH_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION TD_T_DQDH_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION TD_T_DQDH_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION TD_T_DQDH_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION TD_T_DQDH_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION TD_T_DQDH_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION TD_T_DQDH_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION TD_T_DQDH_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM TD_T_DQDH_BAK;

DROP TABLE TD_T_DQDH_BAK;




rm /tmp/pipo_TD_T_DQDH_2006
mknod /tmp/pipo_TD_T_DQDH_2006 p
compress TD_T_DQDH_2006.dmp.Z & exp zjda/password file=/tmp/pipo_TD_T_DQDH_2006 tables=TD_T_DQDH:TD_T_DQDH_2006
rm /tmp/pipo_TD_T_DQDH_2006   

alter table TD_T_DQDH drop PARTITION TD_T_DQDH_2006;




15    零星验单表    TD_T_LXYD

RENAME TD_T_LXYD TO TD_T_LXYD_BAK;
create table TD_T_LXYD PARTITION BY RANGE (C_CZNF)
(
PARTITION TD_T_LXYD_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION TD_T_LXYD_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION TD_T_LXYD_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION TD_T_LXYD_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION TD_T_LXYD_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION TD_T_LXYD_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION TD_T_LXYD_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION TD_T_LXYD_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION TD_T_LXYD_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION TD_T_LXYD_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION TD_T_LXYD_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM TD_T_LXYD_BAK;

DROP TABLE TD_T_LXYD_BAK;



rm /tmp/pipo_TD_T_LXYD_2006
mknod /tmp/pipo_TD_T_LXYD_2006 p
compress TD_T_LXYD_2006.dmp.Z & exp zjda/password file=/tmp/pipo_TD_T_LXYD_2006 tables=TD_T_LXYD:TD_T_LXYD_2006
rm /tmp/pipo_TD_T_LXYD_2006   


alter table TD_T_LXYD drop PARTITION TD_T_LXYD_2006;




16    投递卡片表    TD_T_YHSJB

RENAME TD_T_YHSJB TO TD_T_YHSJB_BAK;
create table TD_T_YHSJB PARTITION BY RANGE (C_CZNF)
(
PARTITION TD_T_YHSJB_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION TD_T_YHSJB_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION TD_T_YHSJB_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION TD_T_YHSJB_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION TD_T_YHSJB_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION TD_T_YHSJB_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION TD_T_YHSJB_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION TD_T_YHSJB_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION TD_T_YHSJB_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION TD_T_YHSJB_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION TD_T_YHSJB_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM TD_T_YHSJB_BAK;

DROP TABLE TD_T_YHSJB_BAK;


17    余缺登记表    TD_T_YQDJB
RENAME TD_T_YQDJB TO TD_T_YQDJB_BAK;
create table TD_T_YQDJB PARTITION BY RANGE (C_CZNF)
(
PARTITION TD_T_YQDJB_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION TD_T_YQDJB_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION TD_T_YQDJB_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION TD_T_YQDJB_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION TD_T_YQDJB_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION TD_T_YQDJB_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION TD_T_YQDJB_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION TD_T_YQDJB_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION TD_T_YQDJB_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION TD_T_YQDJB_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION TD_T_YQDJB_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM TD_T_YQDJB_BAK;

DROP TABLE TD_T_YQDJB_BAK;

rm /tmp/pipo_TD_T_YQDJB_2006
mknod /tmp/pipo_TD_T_YQDJB_2006 p
compress TD_T_YQDJB_2006.dmp.Z & exp zjda/password file=/tmp/pipo_TD_T_YQDJB_2006 tables=TD_T_YQDJB:TD_T_YQDJB_2006
rm /tmp/pipo_TD_T_YQDJB_2006   


alter table TD_T_YQDJB drop PARTITION TD_T_YQDJB_2006;




18    重点操作流程    TD_T_ZDCZLC
RENAME TD_T_ZDCZLC TO TD_T_ZDCZLC_BAK;
create table TD_T_ZDCZLC PARTITION BY RANGE (C_CZNF)
(
PARTITION TD_T_ZDCZLC_2006 VALUES LESS THAN ('2007') TABLESPACE ZJDADATA,
PARTITION TD_T_ZDCZLC_2007 VALUES LESS THAN ('2008') TABLESPACE ZJDADATA,
PARTITION TD_T_ZDCZLC_2008 VALUES LESS THAN ('2009') TABLESPACE ZJDADATA,
PARTITION TD_T_ZDCZLC_2009 VALUES LESS THAN ('2010') TABLESPACE ZJDADATA,
PARTITION TD_T_ZDCZLC_2010 VALUES LESS THAN ('2011') TABLESPACE ZJDADATA,
PARTITION TD_T_ZDCZLC_2011 VALUES LESS THAN ('2012') TABLESPACE ZJDADATA,
PARTITION TD_T_ZDCZLC_2012 VALUES LESS THAN ('2013') TABLESPACE ZJDADATA,
PARTITION TD_T_ZDCZLC_2013 VALUES LESS THAN ('2014') TABLESPACE ZJDADATA,
PARTITION TD_T_ZDCZLC_2014 VALUES LESS THAN ('2015') TABLESPACE ZJDADATA,
PARTITION TD_T_ZDCZLC_2015 VALUES LESS THAN ('2016') TABLESPACE ZJDADATA,
PARTITION TD_T_ZDCZLC_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM TD_T_ZDCZLC_BAK;

DROP TABLE TD_T_ZDCZLC_BAK;



rm /tmp/pipo_TD_T_ZDCZLC_2006
mknod /tmp/pipo_TD_T_ZDCZLC_2006 p
compress TD_T_ZDCZLC_2006.dmp.Z & exp zjda/password file=/tmp/pipo_TD_T_ZDCZLC_2006 tables=TD_T_ZDCZLC:TD_T_ZDCZLC_2006
rm /tmp/pipo_TD_T_ZDCZLC_2006   

alter table TD_T_ZDCZLC drop PARTITION TD_T_ZDCZLC_2006;


19    员工登录表    ZHW_T_YGDL
RENAME ZHW_T_YGDL TO ZHW_T_YGDL_BAK;
create table ZHW_T_YGDL PARTITION BY RANGE (C_DLSJ)
(
PARTITION ZHW_T_YGDL_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZHW_T_YGDL_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZHW_T_YGDL_BAK;

DROP TABLE ZHW_T_YGDL_BAK;



rm /tmp/pipo_ZHW_T_YGDL_20050101
mknod /tmp/pipo_ZHW_T_YGDL_20050101 p
compress ZHW_T_YGDL_20050101.dmp.Z & exp zjda/password file=/tmp/pipo_ZHW_T_YGDL_20050101 tables=ZHW_T_YGDL:ZHW_T_YGDL_20050101
rm /tmp/pipo_ZHW_T_YGDL_20050101

alter table ZHW_T_YGDL drop PARTITION ZHW_T_YGDL_20050101;



rm /tmp/pipo_ZHW_T_YGDL_20050701
mknod /tmp/pipo_ZHW_T_YGDL_20050701 p
compress ZHW_T_YGDL_20050701.dmp.Z & exp zjda/password file=/tmp/pipo_ZHW_T_YGDL_20050701 tables=ZHW_T_YGDL:ZHW_T_YGDL_20050701
rm /tmp/pipo_ZHW_T_YGDL_20050701   

alter table ZHW_T_YGDL drop PARTITION ZHW_T_YGDL_20050701;

exp zjda/password file=/BACKUP/zjda_tmp/ZHW_T_YGDL_20050701.dmp tables=ZHW_T_YGDL:ZHW_T_YGDL_20050701

rm /tmp/pipo_ZHW_T_YGDL_20060101
mknod /tmp/pipo_ZHW_T_YGDL_20060101 p
compress ZHW_T_YGDL_20060101.dmp.Z &
exp zjda/password file=/BACKUP/zjda_tmp/ZHW_T_YGDL_20060101.dmp tables=ZHW_T_YGDL:ZHW_T_YGDL_20060101
rm /tmp/pipo_ZHW_T_YGDL_20060101   

alter table ZHW_T_YGDL drop PARTITION ZHW_T_YGDL_20060101;

rm /tmp/pipo_ZHW_T_YGDL_20060701
mknod /tmp/pipo_ZHW_T_YGDL_20060701 p
compress ZHW_T_YGDL_20060701.dmp.Z &
exp zjda/password file=/BACKUP/zjda_tmp/pipo_ZHW_T_YGDL_20060701.dmp tables=ZHW_T_YGDL:ZHW_T_YGDL_20060701
rm /tmp/pipo_ZHW_T_YGDL_20060701   

alter table ZHW_T_YGDL drop PARTITION ZHW_T_YGDL_20060701;

rm /tmp/pipo_ZHW_T_YGDL_20070101
mknod /tmp/pipo_ZHW_T_YGDL_20070101 p
compress ZHW_T_YGDL_20070101.dmp.Z &
exp zjda/password file=/BACKUP/zjda_tmp/pipo_ZHW_T_YGDL_20070101.dmp tables=ZHW_T_YGDL:ZHW_T_YGDL_20070101
rm /tmp/pipo_ZHW_T_YGDL_20070101   

alter table ZHW_T_YGDL drop PARTITION ZHW_T_YGDL_20070101;





20    窗投邮件信息表    ZJCT_T_CTYJ    D_JSRQ

RENAME ZJCT_T_CTYJ TO ZJCT_T_CTYJ_BAK;
create table ZJCT_T_CTYJ PARTITION BY RANGE (D_JSRQ)
(
PARTITION ZJCT_T_CTYJ_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJCT_T_CTYJ_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJCT_T_CTYJ_BAK;

DROP TABLE ZJCT_T_CTYJ_BAK;




"rm /tmp/pipo_ZJCT_T_CTYJ_20050101
mknod /tmp/pipo_ZJCT_T_CTYJ_20050101 p
compress ZJCT_T_CTYJ_20050101.dmp.Z &


exp zjda/password file=/BACKUP/zjda_tmp/ZJCT_T_CTYJ_20050101.dmp tables=ZJCT_T_CTYJ:ZJCT_T_CTYJ_20050101

rm /tmp/pipo_ZJCT_T_CTYJ_20050101"
"rm /tmp/pipo_ZJCT_T_CTYJ_20050701
mknod /tmp/pipo_ZJCT_T_CTYJ_20050701 p
compress ZJCT_T_CTYJ_20050701.dmp.Z &


exp zjda/password file=/BACKUP/zjda_tmp/ZJCT_T_CTYJ_20050701 tables=ZJCT_T_CTYJ:ZJCT_T_CTYJ_20050701
rm /tmp/pipo_ZJCT_T_CTYJ_20050701"
"rm /tmp/pipo_ZJCT_T_CTYJ_20060101
mknod /tmp/pipo_ZJCT_T_CTYJ_20060101 p
compress ZJCT_T_CTYJ_20060101.dmp.Z &


exp zjda/password file=/BACKUP/zjda_tmp/ZJCT_T_CTYJ_20060101 tables=ZJCT_T_CTYJ:ZJCT_T_CTYJ_20060101
rm /tmp/pipo_ZJCT_T_CTYJ_20060101"
"rm /tmp/pipo_ZJCT_T_CTYJ_20060701
mknod /tmp/pipo_ZJCT_T_CTYJ_20060701 p
compress ZJCT_T_CTYJ_20060701.dmp.Z &


exp zjda/password file=/BACKUP/zjda_tmp/ZJCT_T_CTYJ_20060701 tables=ZJCT_T_CTYJ:ZJCT_T_CTYJ_20060701
rm /tmp/pipo_ZJCT_T_CTYJ_20060701"
"rm /tmp/pipo_ZJCT_T_CTYJ_20070101
mknod /tmp/pipo_ZJCT_T_CTYJ_20070101 p
compress ZJCT_T_CTYJ_20070101.dmp.Z &


exp zjda/password file=/BACKUP/zjda_tmp/ZJCT_T_CTYJ_20070101 tables=ZJCT_T_CTYJ:ZJCT_T_CTYJ_20070101
rm /tmp/pipo_ZJCT_T_CTYJ_20070101"

alter table ZJCT_T_CTYJ drop PARTITION ZJCT_T_CTYJ_20050101;
alter table ZJCT_T_CTYJ drop PARTITION ZJCT_T_CTYJ_20050701;
alter table ZJCT_T_CTYJ drop PARTITION ZJCT_T_CTYJ_20060101;
alter table ZJCT_T_CTYJ drop PARTITION ZJCT_T_CTYJ_20060701;
alter table ZJCT_T_CTYJ drop PARTITION ZJCT_T_CTYJ_20070101;




21    投递反馈信息表    ZJTD_T_TDFKXX    D_LRSJ

RENAME ZJTD_T_TDFKXX TO ZJTD_T_TDFKXX_BAK;
create table ZJTD_T_TDFKXX PARTITION BY RANGE (D_LRSJ)
(
PARTITION ZJTD_T_TDFKXX_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDFKXX_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJTD_T_TDFKXX_BAK;

DROP TABLE ZJTD_T_TDFKXX_BAK;



exp zjda/password file=/BACKUP/zjda_tmp/ZJTD_T_TDFKXX_20050101.dmp tables=ZJTD_T_TDFKXX:ZJTD_T_TDFKXX_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJTD_T_TDFKXX_20050701.dmp tables=ZJTD_T_TDFKXX:ZJTD_T_TDFKXX_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJTD_T_TDFKXX_20060101.dmp tables=ZJTD_T_TDFKXX:ZJTD_T_TDFKXX_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJTD_T_TDFKXX_20060701.dmp tables=ZJTD_T_TDFKXX:ZJTD_T_TDFKXX_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJTD_T_TDFKXX_20070101.dmp tables=ZJTD_T_TDFKXX:ZJTD_T_TDFKXX_20070101

alter table ZJTD_T_TDFKXX drop PARTITION ZJTD_T_TDFKXX_20050101;
alter table ZJTD_T_TDFKXX drop PARTITION ZJTD_T_TDFKXX_20050701;
alter table ZJTD_T_TDFKXX drop PARTITION ZJTD_T_TDFKXX_20060101;
alter table ZJTD_T_TDFKXX drop PARTITION ZJTD_T_TDFKXX_20060701;
alter table ZJTD_T_TDFKXX drop PARTITION ZJTD_T_TDFKXX_20070101;



22    投递信息表    ZJTD_T_TDXX    D_LRRQ
RENAME ZJTD_T_TDXX TO ZJTD_T_TDXX_BAK;
create table ZJTD_T_TDXX PARTITION BY RANGE (D_LRRQ)
(
PARTITION ZJTD_T_TDXX_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTD_T_TDXX_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJTD_T_TDXX_BAK;

DROP TABLE ZJTD_T_TDXX_BAK;




exp zjda/password file=/BACKUP/zjda_tmp/ZJTD_T_TDXX_20050101.dmp tables=ZJTD_T_TDXX:ZJTD_T_TDXX_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJTD_T_TDXX_20050701.dmp tables=ZJTD_T_TDXX:ZJTD_T_TDXX_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJTD_T_TDXX_20060101.dmp tables=ZJTD_T_TDXX:ZJTD_T_TDXX_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJTD_T_TDXX_20060701.dmp tables=ZJTD_T_TDXX:ZJTD_T_TDXX_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJTD_T_TDXX_20070101.dmp tables=ZJTD_T_TDXX:ZJTD_T_TDXX_20070101


alter table ZJTD_T_TDXX drop PARTITION ZJTD_T_TDXX_20050101;
alter table ZJTD_T_TDXX drop PARTITION ZJTD_T_TDXX_20050701;
alter table ZJTD_T_TDXX drop PARTITION ZJTD_T_TDXX_20060101;
alter table ZJTD_T_TDXX drop PARTITION ZJTD_T_TDXX_20060701;
alter table ZJTD_T_TDXX drop PARTITION ZJTD_T_TDXX_20070101;


23    特快统计日报表    ZJTK_T_BZTJ    C_TJRQ
RENAME ZJTK_T_BZTJ TO ZJTK_T_BZTJ_BAK;
create table ZJTK_T_BZTJ PARTITION BY RANGE (C_TJRQ)
(
PARTITION ZJTK_T_BZTJ_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJTK_T_BZTJ_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJTK_T_BZTJ_BAK;

DROP TABLE ZJTK_T_BZTJ_BAK;



exp zjda/password file=/BACKUP/zjda_tmp/ZJTK_T_BZTJ_20050101.dmp tables=ZJTK_T_BZTJ:ZJTK_T_BZTJ_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJTK_T_BZTJ_20050701.dmp tables=ZJTK_T_BZTJ:ZJTK_T_BZTJ_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJTK_T_BZTJ_20060101.dmp tables=ZJTK_T_BZTJ:ZJTK_T_BZTJ_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJTK_T_BZTJ_20060701.dmp tables=ZJTK_T_BZTJ:ZJTK_T_BZTJ_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJTK_T_BZTJ_20070101.dmp tables=ZJTK_T_BZTJ:ZJTK_T_BZTJ_20070101




alter table ZJTK_T_BZTJ drop PARTITION ZJTK_T_BZTJ_20050101;
alter table ZJTK_T_BZTJ drop PARTITION ZJTK_T_BZTJ_20050701;
alter table ZJTK_T_BZTJ drop PARTITION ZJTK_T_BZTJ_20060101;
alter table ZJTK_T_BZTJ drop PARTITION ZJTK_T_BZTJ_20060701;
alter table ZJTK_T_BZTJ drop PARTITION ZJTK_T_BZTJ_20070101;



24    大宗用户交易信息表    ZJYJ_T_DZJY

RENAME ZJYJ_T_DZJY TO ZJYJ_T_DZJY_BAK;
create table ZJYJ_T_DZJY PARTITION BY RANGE (D_SJRQ)
(
PARTITION ZJYJ_T_DZJY_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_DZJY_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJYJ_T_DZJY_BAK;

DROP TABLE ZJYJ_T_DZJY_BAK;





exp zjda/password file=/BACKUP/zjda_tmp/ZJYJ_T_DZJY_20050101.dmp tables=ZJYJ_T_DZJY:ZJYJ_T_DZJY_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJYJ_T_DZJY_20050701.dmp tables=ZJYJ_T_DZJY:ZJYJ_T_DZJY_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJYJ_T_DZJY_20060101.dmp tables=ZJYJ_T_DZJY:ZJYJ_T_DZJY_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJYJ_T_DZJY_20060701.dmp tables=ZJYJ_T_DZJY:ZJYJ_T_DZJY_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJYJ_T_DZJY_20070101.dmp tables=ZJYJ_T_DZJY:ZJYJ_T_DZJY_20070101



alter table ZJYJ_T_DZJY drop PARTITION ZJYJ_T_DZJY_20050101;
alter table ZJYJ_T_DZJY drop PARTITION ZJYJ_T_DZJY_20050701;
alter table ZJYJ_T_DZJY drop PARTITION ZJYJ_T_DZJY_20060101;
alter table ZJYJ_T_DZJY drop PARTITION ZJYJ_T_DZJY_20060701;
alter table ZJYJ_T_DZJY drop PARTITION ZJYJ_T_DZJY_20070101;






25    总包出口登记表    ZJYJ_T_LDSJB

RENAME ZJYJ_T_LDSJB TO ZJYJ_T_LDSJB_BAK;
create table ZJYJ_T_LDSJB PARTITION BY RANGE (D_TJRQ)
(
PARTITION ZJYJ_T_LDSJB_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_LDSJB_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJYJ_T_LDSJB_BAK;

DROP TABLE ZJYJ_T_LDSJB_BAK;




exp zjda/password file=/BACKUP/zjda_tmp/ZJYJ_T_LDSJB_20050101.dmp tables=ZJYJ_T_LDSJB:ZJYJ_T_LDSJB_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJYJ_T_LDSJB_20050701.dmp tables=ZJYJ_T_LDSJB:ZJYJ_T_LDSJB_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJYJ_T_LDSJB_20060101.dmp tables=ZJYJ_T_LDSJB:ZJYJ_T_LDSJB_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJYJ_T_LDSJB_20060701.dmp tables=ZJYJ_T_LDSJB:ZJYJ_T_LDSJB_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJYJ_T_LDSJB_20070101.dmp tables=ZJYJ_T_LDSJB:ZJYJ_T_LDSJB_20070101


alter table ZJYJ_T_LDSJB drop PARTITION ZJYJ_T_LDSJB_20050101;
alter table ZJYJ_T_LDSJB drop PARTITION ZJYJ_T_LDSJB_20050701;
alter table ZJYJ_T_LDSJB drop PARTITION ZJYJ_T_LDSJB_20060101;
alter table ZJYJ_T_LDSJB drop PARTITION ZJYJ_T_LDSJB_20060701;
alter table ZJYJ_T_LDSJB drop PARTITION ZJYJ_T_LDSJB_20070101;




26    原始收寄信息表    ZJYJ_T_YSSJ

RENAME ZJYJ_T_YSSJ TO ZJYJ_T_YSSJ_BAK;
create table ZJYJ_T_YSSJ PARTITION BY RANGE (D_SJRQ)
(
PARTITION ZJYJ_T_YSSJ_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJYJ_T_YSSJ_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJYJ_T_YSSJ_BAK;

DROP TABLE ZJYJ_T_YSSJ_BAK;




exp zjda/password file=/BACKUP/zjda_tmp/ZJYJ_T_YSSJ_20050101.dmp tables=ZJYJ_T_YSSJ:ZJYJ_T_YSSJ_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJYJ_T_YSSJ_20050701.dmp tables=ZJYJ_T_YSSJ:ZJYJ_T_YSSJ_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJYJ_T_YSSJ_20060101.dmp tables=ZJYJ_T_YSSJ:ZJYJ_T_YSSJ_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJYJ_T_YSSJ_20060701.dmp tables=ZJYJ_T_YSSJ:ZJYJ_T_YSSJ_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJYJ_T_YSSJ_20070101.dmp tables=ZJYJ_T_YSSJ:ZJYJ_T_YSSJ_20070101



alter table ZJYJ_T_YSSJ drop PARTITION ZJYJ_T_YSSJ_20050101;
alter table ZJYJ_T_YSSJ drop PARTITION ZJYJ_T_YSSJ_20050701;
alter table ZJYJ_T_YSSJ drop PARTITION ZJYJ_T_YSSJ_20060101;
alter table ZJYJ_T_YSSJ drop PARTITION ZJYJ_T_YSSJ_20060701;
alter table ZJYJ_T_YSSJ drop PARTITION ZJYJ_T_YSSJ_20070101;



27    大宗导入批次表    ZJ_T_DZPCXX

RENAME ZJ_T_DZPCXX TO ZJ_T_DZPCXX_BAK;
create table ZJ_T_DZPCXX PARTITION BY RANGE (D_DRSJ)
(
PARTITION ZJ_T_DZPCXX_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZPCXX_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJ_T_DZPCXX_BAK;

DROP TABLE ZJ_T_DZPCXX_BAK;





exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_DZPCXX_20050101.dmp tables=ZJ_T_DZPCXX:ZJ_T_DZPCXX_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_DZPCXX_20050701.dmp tables=ZJ_T_DZPCXX:ZJ_T_DZPCXX_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_DZPCXX_20060101.dmp tables=ZJ_T_DZPCXX:ZJ_T_DZPCXX_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_DZPCXX_20060701.dmp tables=ZJ_T_DZPCXX:ZJ_T_DZPCXX_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_DZPCXX_20070101.dmp tables=ZJ_T_DZPCXX:ZJ_T_DZPCXX_20070101


alter table ZJ_T_DZPCXX drop PARTITION ZJ_T_DZPCXX_20050101;
alter table ZJ_T_DZPCXX drop PARTITION ZJ_T_DZPCXX_20050701;
alter table ZJ_T_DZPCXX drop PARTITION ZJ_T_DZPCXX_20060101;
alter table ZJ_T_DZPCXX drop PARTITION ZJ_T_DZPCXX_20060701;
alter table ZJ_T_DZPCXX drop PARTITION ZJ_T_DZPCXX_20070101;



28    大宗导入详细信息表    ZJ_T_DZXXXX

RENAME ZJ_T_DZXXXX TO ZJ_T_DZXXXX_BAK;
create table ZJ_T_DZXXXX PARTITION BY RANGE (D_TBCLSJ)
(
PARTITION ZJ_T_DZXXXX_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_DZXXXX_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJ_T_DZXXXX_BAK;

DROP TABLE ZJ_T_DZXXXX_BAK;



exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_DZXXXX_20050101.dmp tables=ZJ_T_DZXXXX:ZJ_T_DZXXXX_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_DZXXXX_20050701.dmp tables=ZJ_T_DZXXXX:ZJ_T_DZXXXX_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_DZXXXX_20060101.dmp tables=ZJ_T_DZXXXX:ZJ_T_DZXXXX_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_DZXXXX_20060701.dmp tables=ZJ_T_DZXXXX:ZJ_T_DZXXXX_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_DZXXXX_20070101.dmp tables=ZJ_T_DZXXXX:ZJ_T_DZXXXX_20070101




alter table ZJ_T_DZXXXX drop PARTITION ZJ_T_DZXXXX_20050101;
alter table ZJ_T_DZXXXX drop PARTITION ZJ_T_DZXXXX_20050701;
alter table ZJ_T_DZXXXX drop PARTITION ZJ_T_DZXXXX_20060101;
alter table ZJ_T_DZXXXX drop PARTITION ZJ_T_DZXXXX_20060701;
alter table ZJ_T_DZXXXX drop PARTITION ZJ_T_DZXXXX_20070101;









29    个人产量统计表    ZJ_T_GRCLTJ


RENAME ZJ_T_GRCLTJ TO ZJ_T_GRCLTJ_BAK;
create table ZJ_T_GRCLTJ PARTITION BY RANGE (C_TJRQ)
(
PARTITION ZJ_T_GRCLTJ_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRCLTJ_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJ_T_GRCLTJ_BAK;

DROP TABLE ZJ_T_GRCLTJ_BAK;


exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_GRCLTJ_20050101.dmp tables=ZJ_T_GRCLTJ:ZJ_T_GRCLTJ_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_GRCLTJ_20050701.dmp tables=ZJ_T_GRCLTJ:ZJ_T_GRCLTJ_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_GRCLTJ_20060101.dmp tables=ZJ_T_GRCLTJ:ZJ_T_GRCLTJ_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_GRCLTJ_20060701.dmp tables=ZJ_T_GRCLTJ:ZJ_T_GRCLTJ_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_GRCLTJ_20070101.dmp tables=ZJ_T_GRCLTJ:ZJ_T_GRCLTJ_20070101



alter table ZJ_T_GRCLTJ drop PARTITION ZJ_T_GRCLTJ_20050101;
alter table ZJ_T_GRCLTJ drop PARTITION ZJ_T_GRCLTJ_20050701;
alter table ZJ_T_GRCLTJ drop PARTITION ZJ_T_GRCLTJ_20060101;
alter table ZJ_T_GRCLTJ drop PARTITION ZJ_T_GRCLTJ_20060701;
alter table ZJ_T_GRCLTJ drop PARTITION ZJ_T_GRCLTJ_20070101;









30    个人日报统计表    ZJ_T_GRTJ

RENAME ZJ_T_GRTJ TO ZJ_T_GRTJ_BAK;
create table ZJ_T_GRTJ PARTITION BY RANGE (D_TJRQ)
(
PARTITION ZJ_T_GRTJ_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_GRTJ_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJ_T_GRTJ_BAK;

DROP TABLE ZJ_T_GRTJ_BAK;





exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_GRTJ_20050101.dmp tables=ZJ_T_GRTJ:ZJ_T_GRTJ_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_GRTJ_20050701.dmp tables=ZJ_T_GRTJ:ZJ_T_GRTJ_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_GRTJ_20060101.dmp tables=ZJ_T_GRTJ:ZJ_T_GRTJ_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_GRTJ_20060701.dmp tables=ZJ_T_GRTJ:ZJ_T_GRTJ_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_GRTJ_20070101.dmp tables=ZJ_T_GRTJ:ZJ_T_GRTJ_20070101




alter table ZJ_T_GRTJ drop PARTITION ZJ_T_GRTJ_20050101;
alter table ZJ_T_GRTJ drop PARTITION ZJ_T_GRTJ_20050701;
alter table ZJ_T_GRTJ drop PARTITION ZJ_T_GRTJ_20060101;
alter table ZJ_T_GRTJ drop PARTITION ZJ_T_GRTJ_20060701;
alter table ZJ_T_GRTJ drop PARTITION ZJ_T_GRTJ_20070101;




31    后台系统日志    ZJ_T_HTXTRZ

RENAME ZJ_T_HTXTRZ TO ZJ_T_HTXTRZ_BAK;
create table ZJ_T_HTXTRZ PARTITION BY RANGE (D_FSSJ)
(
PARTITION ZJ_T_HTXTRZ_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_HTXTRZ_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJ_T_HTXTRZ_BAK;

DROP TABLE ZJ_T_HTXTRZ_BAK;





exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_HTXTRZ_20050101.dmp tables=ZJ_T_HTXTRZ:ZJ_T_HTXTRZ_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_HTXTRZ_20050701.dmp tables=ZJ_T_HTXTRZ:ZJ_T_HTXTRZ_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_HTXTRZ_20060101.dmp tables=ZJ_T_HTXTRZ:ZJ_T_HTXTRZ_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_HTXTRZ_20060701.dmp tables=ZJ_T_HTXTRZ:ZJ_T_HTXTRZ_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_HTXTRZ_20070101.dmp tables=ZJ_T_HTXTRZ:ZJ_T_HTXTRZ_20070101


alter table ZJ_T_HTXTRZ drop PARTITION ZJ_T_HTXTRZ_20050101;
alter table ZJ_T_HTXTRZ drop PARTITION ZJ_T_HTXTRZ_20050701;
alter table ZJ_T_HTXTRZ drop PARTITION ZJ_T_HTXTRZ_20060101;
alter table ZJ_T_HTXTRZ drop PARTITION ZJ_T_HTXTRZ_20060701;
alter table ZJ_T_HTXTRZ drop PARTITION ZJ_T_HTXTRZ_20070101;



32    路单信息表    ZJ_T_LDXX

RENAME ZJ_T_LDXX TO ZJ_T_LDXX_BAK;
create table ZJ_T_LDXX PARTITION BY RANGE (D_FFRQ)
(
PARTITION ZJ_T_LDXX_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_LDXX_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJ_T_LDXX_BAK;

DROP TABLE ZJ_T_LDXX_BAK;





exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_LDXX_20050101.dmp tables=ZJ_T_LDXX:ZJ_T_LDXX_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_LDXX_20050701.dmp tables=ZJ_T_LDXX:ZJ_T_LDXX_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_LDXX_20060101.dmp tables=ZJ_T_LDXX:ZJ_T_LDXX_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_LDXX_20060701.dmp tables=ZJ_T_LDXX:ZJ_T_LDXX_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_LDXX_20070101.dmp tables=ZJ_T_LDXX:ZJ_T_LDXX_20070101



alter table ZJ_T_LDXX drop PARTITION ZJ_T_LDXX_20050101;
alter table ZJ_T_LDXX drop PARTITION ZJ_T_LDXX_20050701;
alter table ZJ_T_LDXX drop PARTITION ZJ_T_LDXX_20060101;
alter table ZJ_T_LDXX drop PARTITION ZJ_T_LDXX_20060701;
alter table ZJ_T_LDXX drop PARTITION ZJ_T_LDXX_20070101;





33    清单详情信息表    ZJ_T_QDXQ

RENAME ZJ_T_QDXQ TO ZJ_T_QDXQ_BAK;
create table ZJ_T_QDXQ PARTITION BY RANGE (D_FFRQ)
(
PARTITION ZJ_T_QDXQ_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXQ_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJ_T_QDXQ_BAK;

DROP TABLE ZJ_T_QDXQ_BAK;






exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_QDXQ_20050101.dmp tables=ZJ_T_QDXQ:ZJ_T_QDXQ_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_QDXQ_20050701.dmp tables=ZJ_T_QDXQ:ZJ_T_QDXQ_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_QDXQ_20060101.dmp tables=ZJ_T_QDXQ:ZJ_T_QDXQ_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_QDXQ_20060701.dmp tables=ZJ_T_QDXQ:ZJ_T_QDXQ_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_QDXQ_20070101.dmp tables=ZJ_T_QDXQ:ZJ_T_QDXQ_20070101



alter table ZJ_T_QDXQ drop PARTITION ZJ_T_QDXQ_20050101;
alter table ZJ_T_QDXQ drop PARTITION ZJ_T_QDXQ_20050701;
alter table ZJ_T_QDXQ drop PARTITION ZJ_T_QDXQ_20060101;
alter table ZJ_T_QDXQ drop PARTITION ZJ_T_QDXQ_20060701;
alter table ZJ_T_QDXQ drop PARTITION ZJ_T_QDXQ_20070101;







34    清单信息表    ZJ_T_QDXX

RENAME ZJ_T_QDXX TO ZJ_T_QDXX_BAK;
create table ZJ_T_QDXX PARTITION BY RANGE (D_FFRQ)
(
PARTITION ZJ_T_QDXX_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QDXX_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJ_T_QDXX_BAK;

DROP TABLE ZJ_T_QDXX_BAK;



exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_QDXX_20050101.dmp tables=ZJ_T_QDXX:ZJ_T_QDXX_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_QDXX_20050701.dmp tables=ZJ_T_QDXX:ZJ_T_QDXX_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_QDXX_20060101.dmp tables=ZJ_T_QDXX:ZJ_T_QDXX_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_QDXX_20060701.dmp tables=ZJ_T_QDXX:ZJ_T_QDXX_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_QDXX_20070101.dmp tables=ZJ_T_QDXX:ZJ_T_QDXX_20070101




alter table ZJ_T_QDXX drop PARTITION ZJ_T_QDXX_20050101;
alter table ZJ_T_QDXX drop PARTITION ZJ_T_QDXX_20050701;
alter table ZJ_T_QDXX drop PARTITION ZJ_T_QDXX_20060101;
alter table ZJ_T_QDXX drop PARTITION ZJ_T_QDXX_20060701;
alter table ZJ_T_QDXX drop PARTITION ZJ_T_QDXX_20070101;




35    前台系统日志表    ZJ_T_QTXTRZ

RENAME ZJ_T_QTXTRZ TO ZJ_T_QTXTRZ_BAK;
create table ZJ_T_QTXTRZ PARTITION BY RANGE (D_FSSJ)
(
PARTITION ZJ_T_QTXTRZ_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_QTXTRZ_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJ_T_QTXTRZ_BAK;

DROP TABLE ZJ_T_QTXTRZ_BAK;



exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_QTXTRZ_20050101.dmp tables=ZJ_T_QTXTRZ:ZJ_T_QTXTRZ_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_QTXTRZ_20050701.dmp tables=ZJ_T_QTXTRZ:ZJ_T_QTXTRZ_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_QTXTRZ_20060101.dmp tables=ZJ_T_QTXTRZ:ZJ_T_QTXTRZ_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_QTXTRZ_20060701.dmp tables=ZJ_T_QTXTRZ:ZJ_T_QTXTRZ_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_QTXTRZ_20070101.dmp tables=ZJ_T_QTXTRZ:ZJ_T_QTXTRZ_20070101





alter table ZJ_T_QTXTRZ drop PARTITION ZJ_T_QTXTRZ_20050101;
alter table ZJ_T_QTXTRZ drop PARTITION ZJ_T_QTXTRZ_20050701;
alter table ZJ_T_QTXTRZ drop PARTITION ZJ_T_QTXTRZ_20060101;
alter table ZJ_T_QTXTRZ drop PARTITION ZJ_T_QTXTRZ_20060701;
alter table ZJ_T_QTXTRZ drop PARTITION ZJ_T_QTXTRZ_20070101;




36    邮件发票表    ZJ_T_YJFP

RENAME ZJ_T_YJFP TO ZJ_T_YJFP_BAK;
create table ZJ_T_YJFP PARTITION BY RANGE (D_SJRQ)
(
PARTITION ZJ_T_YJFP_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_YJFP_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJ_T_YJFP_BAK;

DROP TABLE ZJ_T_YJFP_BAK;



exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_YJFP_20050101.dmp tables=ZJ_T_YJFP:ZJ_T_YJFP_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_YJFP_20050701.dmp tables=ZJ_T_YJFP:ZJ_T_YJFP_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_YJFP_20060101.dmp tables=ZJ_T_YJFP:ZJ_T_YJFP_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_YJFP_20060701.dmp tables=ZJ_T_YJFP:ZJ_T_YJFP_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_YJFP_20070101.dmp tables=ZJ_T_YJFP:ZJ_T_YJFP_20070101



alter table ZJ_T_YJFP drop PARTITION ZJ_T_YJFP_20050101;
alter table ZJ_T_YJFP drop PARTITION ZJ_T_YJFP_20050701;
alter table ZJ_T_YJFP drop PARTITION ZJ_T_YJFP_20060101;
alter table ZJ_T_YJFP drop PARTITION ZJ_T_YJFP_20060701;
alter table ZJ_T_YJFP drop PARTITION ZJ_T_YJFP_20070101;





37    支局产量统计表    ZJ_T_ZJCLTJ

RENAME ZJ_T_ZJCLTJ TO ZJ_T_ZJCLTJ_BAK;
create table ZJ_T_ZJCLTJ PARTITION BY RANGE (C_TJRQ)
(
PARTITION ZJ_T_ZJCLTJ_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJCLTJ_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJ_T_ZJCLTJ_BAK;

DROP TABLE ZJ_T_ZJCLTJ_BAK;




exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_ZJCLTJ_20050101.dmp tables=ZJ_T_ZJCLTJ:ZJ_T_ZJCLTJ_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_ZJCLTJ_20050701.dmp tables=ZJ_T_ZJCLTJ:ZJ_T_ZJCLTJ_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_ZJCLTJ_20060101.dmp tables=ZJ_T_ZJCLTJ:ZJ_T_ZJCLTJ_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_ZJCLTJ_20060701.dmp tables=ZJ_T_ZJCLTJ:ZJ_T_ZJCLTJ_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_ZJCLTJ_20070101.dmp tables=ZJ_T_ZJCLTJ:ZJ_T_ZJCLTJ_20070101




alter table ZJ_T_ZJCLTJ drop PARTITION ZJ_T_ZJCLTJ_20050101;
alter table ZJ_T_ZJCLTJ drop PARTITION ZJ_T_ZJCLTJ_20050701;
alter table ZJ_T_ZJCLTJ drop PARTITION ZJ_T_ZJCLTJ_20060101;
alter table ZJ_T_ZJCLTJ drop PARTITION ZJ_T_ZJCLTJ_20060701;
alter table ZJ_T_ZJCLTJ drop PARTITION ZJ_T_ZJCLTJ_20070101;


38    支局日报统计表    ZJ_T_ZJTJ

RENAME ZJ_T_ZJTJ TO ZJ_T_ZJTJ_BAK;
create table ZJ_T_ZJTJ PARTITION BY RANGE (D_TJRQ)
(
PARTITION ZJ_T_ZJTJ_20050101 VALUES LESS THAN (TO_DATE('20050101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20050701 VALUES LESS THAN (TO_DATE('20050701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20060101 VALUES LESS THAN (TO_DATE('20060101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20060701 VALUES LESS THAN (TO_DATE('20060701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20070101 VALUES LESS THAN (TO_DATE('20070101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20070701 VALUES LESS THAN (TO_DATE('20070701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20080101 VALUES LESS THAN (TO_DATE('20080101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20080701 VALUES LESS THAN (TO_DATE('20080701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20090101 VALUES LESS THAN (TO_DATE('20090101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20090701 VALUES LESS THAN (TO_DATE('20090701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20100101 VALUES LESS THAN (TO_DATE('20100101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20100701 VALUES LESS THAN (TO_DATE('20100701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20110101 VALUES LESS THAN (TO_DATE('20110101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20110701 VALUES LESS THAN (TO_DATE('20110701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20120101 VALUES LESS THAN (TO_DATE('20120101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20120701 VALUES LESS THAN (TO_DATE('20120701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20130101 VALUES LESS THAN (TO_DATE('20130101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20130701 VALUES LESS THAN (TO_DATE('20130701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20140101 VALUES LESS THAN (TO_DATE('20140101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20140701 VALUES LESS THAN (TO_DATE('20140701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20150101 VALUES LESS THAN (TO_DATE('20150101','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_20150701 VALUES LESS THAN (TO_DATE('20150701','YYYYMMDD')) TABLESPACE ZJDADATA,
PARTITION ZJ_T_ZJTJ_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE ZJDADATA) PARALLEL(DEGREE 4)
AS SELECT * FROM ZJ_T_ZJTJ_BAK;

DROP TABLE ZJ_T_ZJTJ_BAK;




exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_ZJTJ_20050101.dmp tables=ZJ_T_ZJTJ:ZJ_T_ZJTJ_20050101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_ZJTJ_20050701.dmp tables=ZJ_T_ZJTJ:ZJ_T_ZJTJ_20050701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_ZJTJ_20060101.dmp tables=ZJ_T_ZJTJ:ZJ_T_ZJTJ_20060101
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_ZJTJ_20060701.dmp tables=ZJ_T_ZJTJ:ZJ_T_ZJTJ_20060701
exp zjda/password file=/BACKUP/zjda_tmp/ZJ_T_ZJTJ_20070101.dmp tables=ZJ_T_ZJTJ:ZJ_T_ZJTJ_20070101


alter table ZJ_T_ZJTJ drop PARTITION ZJ_T_ZJTJ_20050101;
alter table ZJ_T_ZJTJ drop PARTITION ZJ_T_ZJTJ_20050701;
alter table ZJ_T_ZJTJ drop PARTITION ZJ_T_ZJTJ_20060101;
alter table ZJ_T_ZJTJ drop PARTITION ZJ_T_ZJTJ_20060701;
alter table ZJ_T_ZJTJ drop PARTITION ZJ_T_ZJTJ_20070101;

阅读(1125) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~