预览加载中，请您耐心等待几秒...

db2表分区实例.docx

预览
1/5
2/5
3/5
4/5
5/5

在线预览结束，喜欢就下载吧，查找使用更方便

下载提示 文本预览

如果您无法下载资料，请参考说明：

1、部分资料下载需要金币，请确保您的账户上有足够的金币

2、已购买过的文档，再次下载不重复扣费

3、资料包下载后请先用软件解压，在使用对应软件打开

droptable"MIBS"."IMAGEINFO_HIS"; CREATETABLE"MIBS"."IMAGEINFO_HIS" ("ID"BIGINTNOTNULLGENERATEDBYDEFAULT ASIDENTITY(STARTWITH1,INCREMENTBY1,CACHE20,MINVALUE1,MAXVALUE9223372036854775807,NOCYCLE,NOORDER), "BATCHNUM"INTEGER, "STORETIME"DATENOTNULL, "IMAGEPATH"VARCHAR(500), "IMAGESTAMP"VARCHAR(1)NOTNULL, "SCANTYPE"SMALLINTNOTNULL, "USERFLAG"SMALLINTNOTNULL, "IMAGEOBJECT"BLOB(10485760)LOGGEDNOTCOMPACT, "FACEFLAG"VARCHAR(1)NOTNULL, "BATCHSN"VARCHAR(22)NOTNULL, "SEQUENCESN"VARCHAR(4)NOTNULL, "BPCERTIFICATETYPE"VARCHAR(1)NOTNULL, "IMAGESN"VARCHAR(20)NOTNULL ) IN"TSP_MIBSSE"LONGIN"TSP_BLOB" PARTITIONBYRANGE(STORETIMENULLSLAST) (PARTITIONpart20130601STARTING'2013-06-01'ENDING'2013-06-01'); ALTERTABLE"MIBS"."IMAGEINFO_HIS" ADDPRIMARYKEY ("ID" ); CREATEINDEX"MIBS"."IMAGEINFO_HIS_BATCHSN_INDEX" ON"MIBS"."IMAGEINFO_HIS" ("BATCHSN"ASC ) PCTFREE10 ALLOWREVERSESCANS; CREATEINDEX"MIBS"."IMAGEINFO_HIS_IMAGESN_INDEX" ON"MIBS"."IMAGEINFO_HIS" ("IMAGESN"ASC ) PCTFREE10 ALLOWREVERSESCANS; CREATEINDEX"MIBS"."IMAGEINFO_HIS_USERFLAG" ON"MIBS"."IMAGEINFO_HIS" ("USERFLAG"ASC ) PCTFREE10 ALLOWREVERSESCANS; GRANTSELECTONTABLE"MIBS"."IMAGEINFO_HIS"TOUSER"DBVIEW"; --Endofgeneratedscriptfor197.3.136.26-MIBS2VES-XBIMAGE(mibs) altertableMIBS.IMAGEINFO_HISTMPaddpartitionpart20130601starting'2013-06-01'ending'2013-06-01'IN"TSP_MIBSSE"LONGIN"TSP_BLOB"; altertableMIBS.IMAGEINFO_HISTMPaddpartitionpart20130602starting'2013-06-02'ending'2013-06-02'IN"TSP_MIBSSE"LONGIN"TSP_BLOB"; altertableMIBS.IMAGEINFO_HISTMPaddpartitionpart20130603starting'2013-06-03'ending'2013-06-03'IN"TSP_MIBSSE"LONGIN"TSP_BLOB"; altertableMIBS.IMAGEINFO_HISTMPaddpartitionpart20130604starting'2013-06-04'ending'2013-06-04'IN"TSP_MIBSSE"LONGIN"TSP_BLOB"; altertableMIBS.IMAGEINFO_HISTMPaddpartitionpart20130605starting'2013-06-05'ending'2013-06-05'IN"TSP_MIBSSE"LONGIN"TSP_BLOB"; altertableMIBS.IMAGEINFO_HISTMPaddpartitionpart20130606starting'2013-06-06'ending'2013-06-06'IN"TSP_MIBSSE"LONGIN"TSP_BLOB"; altertableMIBS.IMAGEINFO_HIS