数据库分区策略查询
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
select a.workID, a.feedback
from ngcrm_zh.OM_WL_LOG partition(P201209) a,ngcrm_zh.cs_rec_reception b
where a.WORKTYPE <> 99
and a.status = 2
and a.RESULT = 'ERROR'
and a.RECDATE >= trunc(sysdate,'MM')
and a.SEND_COUNT = a.MAX_PROCNUM
and a.ORDERID = b.OID
and b.RECDEFID in ('FamilyInstall','GroupMemberMgr')
and a.OPERTYPE='N'
and b.RECDATE >= trunc(sysdate,'MM')
and exists (select 1 from ngcrm_zh.om_wl_worklist where workID = a.workID) and not exists (select 1 from ngcrm_zh.om_wl_log partition(P201209) where workID = a.workID and status='1') and exists (select * from ngcrm_zh.CM_GROUP_MEMBER a1 where a1.MEMSUBSID=b.subsid and a1.SHORTNUMBER like '55_' and STATUS='stcmNml' and STARTDATE
ngcrm_zh@szh >select * from dba_segments where SEGMENT_NAME='OM_WL_LOG' and OWNER='NGCRM_ZH' ;
OWNER SEGMENT_NAME PARTITION_NAME SEGMENT_TYPE SEGMENT_SUBTYPE TABLESPACE_NAME HEADER_FILE HEADER_BLOCK BYTES BLOCKS EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS MAX_SIZE RETENTION MINRETENTION PCT_INCREASE FREELISTS FREELIST_GROUPS RELATIVE_FNO BUFFER_POOL FLASH_CACHE CELL_FLASH_CACH
-------- ------------ -------------- --------------- --------------- --------------- ----------- ------------ ---------- ------ ------- -------------- ----------- ----------- ----------- ---------- --------- ------------ ------------ --------- --------------- ------------ ----------- ----------- ---------------
NGCRM_ZH OM_WL_LOG P201209 TABLE PARTITION ASSM ZH_OM_DATA 106 2964739 4045406208 493824 3858 1048576 1048576 1 2147483645 2147483645 0 106 DEFAULT DEFAULT DEFAULT
NGCRM_ZH OM_WL_LOG P201208 TABLE PARTITION ASSM ZH_OM_DATA 105 3497347 4074766336 497408 3886 1048576 1048576 1 2147483645 2147483645 0 105 DEFAULT DEFAULT DEFAULT
NGCRM_ZH OM_WL_LOG P201207 TABLE PARTITION ASSM ZH_OM_DATA 104 2998403 6307184640 769920 6015 1048576 1048576 1 2147483645 2147483645 0 104 DEFAULT DEFAULT DEFAULT
NGCRM_ZH OM_WL_LOG P201206 TABLE PARTITION ASSM ZH_OM_DATA 102 2714243 6356467712 775936 6062 1048576 1048576 1 2147483645 2147483645 0 102 DEFAULT DEFAULT DEFAULT
NGCRM_ZH OM_WL_LOG P201205 TABLE PARTITION ASSM ZH_OM_DATA 97 3194371 4155506688 507264 3963 1048576 1048576 1
2147483645 2147483645 0 97 DEFAULT DEFAULT DEFAULT
NGCRM_ZH OM_WL_LOG P201204 TABLE PARTITION ASSM ZH_OM_DATA 95 1683459 3894411264 475392 3714 1048576 1048576 1 2147483645 2147483645 0 95 DEFAULT DEFAULT DEFAULT
NGCRM_ZH OM_WL_LOG P201203 TABLE PARTITION ASSM ZH_OM_DATA 91 1486467 4257218560 519680 4060 1048576 1048576 1 2147483645 2147483645 0 91 DEFAULT DEFAULT DEFAULT
NGCRM_ZH OM_WL_LOG P201202 TABLE PARTITION ASSM ZH_OM_DATA 85 2043139 4402970624 537472 4199 1048576 1048576 1 2147483645 2147483645 0 85 DEFAULT DEFAULT DEFAULT
NGCRM_ZH OM_WL_LOG P201201 TABLE PARTITION ASSM ZH_OM_DATA 80 632963 3346006016 408448 3191 1048576 1048576 1 2147483645 2147483645 0 80 DEFAULT DEFAULT DEFAULT
NGCRM_ZH OM_WL_LOG P201112 TABLE PARTITION ASSM ZH_OM_DATA 28 1525891 3562012672 434816 3397 1048576 1048576 1 2147483645 2147483645 0 28 DEFAULT DEFAULT DEFAULT
NGCRM_ZH OM_WL_LOG P201111 TABLE PARTITION ASSM ZH_OM_DATA 27 785667 2167406592 264576 2067 1048576 1048576 1 2147483645 2147483645 0 27 DEFAULT DEFAULT DEFAULT
NGCRM_ZH OM_WL_LOG P201110 TABLE PARTITION ASSM ZH_OM_DATA 27 529795 830472192 101376 792 1048576 1048576 1 2147483645 2147483645 0 27 DEFAULT DEFAULT DEFAULT
12 rows selected.
'139********',
'139********',
'137********',
'136********'
PARTITION "P201106" VALUES LESS THAN (TO_DATE(' 2011-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "ZH_OM_DATA" ,
PARTITION "P201107" VALUES LESS THAN (TO_DATE(' 2011-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAG
E( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "ZH_OM_DATA" ,
SELECT p.table_name AS 表名, decode(p.partitioning_key_count, 1, '主分区') AS 分区类型,
p.partitioning_type AS 分区类型, p.column_name AS 分区键,
decode(nvl(q.subpartitioning_key_count, 0), 0, '无子分区', 1, '子分区') AS 有无子分区,
q.subpartitioning_type AS 子分区类型, q.column_name AS 子分区键
FROM (SELECT a.table_name, a.partitioning_type, b.column_name, a.partitioning_key_count
FROM user_part_tables a, user_part_key_columns b
WHERE a.table_name =
AND b.object_type = 'TABLE') p,
(SELECT a.table_name, a.subpartitioning_type, b.column_name, a.subpartitioning_key_count
FROM user_part_tables a, user_subpart_key_columns b
WHERE a.table_name =
AND a.subpartitioning_key_count <> 0
AND b.object_type = 'TABLE') q
WHERE p.table_name = q.table_name(+)
ORDER BY 5,4,1;
select OBJECT_NAME,SUBOBJECT_NAME from dba_objects where SUBOBJECT_NAME='P201210' and OBJECT_TYPE='TABLE PARTITION';
P201210
BIN$wUaf0ioZgFTgQwr7IyGAVA==$0
PC_PP_BUSILOGDETA
SA_ADM_LOG
select SUBOBJECT_NAME from dba_objects where OBJECT_NAME='SA_ADM_LOG' and OBJECT_TYPE='TABLE PARTITION';
=========================================================
蔡奋争(蔡奋争) 22:40:52
蔡奋争(蔡奋争) 22:42:23
刘妮(刘妮) 22:57:23
CM_SUBS_PRODUCT
蔡奋争(蔡奋争) 23:21:37
ngcrm_fs@SFS >SELECT p.table_name AS 表名, decode(p.partitioning_key_count, 1, '主分区') AS 分区类型,
p.partitioning_type AS 分区类型, p.column_name AS 分区键,
decode(nvl(q.subpartitioning_key_count, 0), 0, '无子分区', 1, '子分区') AS 有无子分区,
q.subpartitioning_type AS 子分区类型, q.column_name AS 子分区键
FROM (SELECT a.table_name, a.partitioning_type, b.column_name, a.partitioning_key_count
FROM user_part_tables a, user_part_key_columns b
WHERE a.table_name =
AND b.object_type = 'TABLE') p,
(SELECT a.table_name, a.subpartitioning_type, b.column_name, a.subpartitioning_key_count
FROM user_part_tables a, user_subpart_key_columns b
WHERE a.table_name =
AND a.subpartitioning_key_count <> 0
AND b.object_type = 'TABLE') q
WHERE p.table_name = q.table_name(+)
ORDER BY 5,4,1;
=========================================================
liuni(cx刘妮) 23:23:40
SELECT p.table_name AS 表名, decode(p.partitioning_key_count, 1, '主分区') AS 分区类型,
p.partitioning_type AS 分区类型, p.column_name AS 分区键,
decode(nvl(q.subpartitioning_key_count, 0), 0, '无子分区', 1, '子分区') AS 有无子分区,
q.subpartitioning_type AS 子分区类型, q.column_name AS 子分区键
FROM (SELECT a.table_name, a.partitioning_type, b.column_name, a.partitioning_key_count
FROM user_part_tables a, user_part_key_columns b
WHERE a.table_name =
AND b.object_type = 'TABLE') p,
(SELECT a.table_name, a.subpartitioning_type, b.column_name, a.
subpartitioning_key_count
FROM user_pa
liuni(cx刘妮) 23:23:40
rt_tables a, user_subpart_key_columns b
WHERE a.table_name =
AND a.subpartitioning_key_count <> 0
AND b.object_type = 'TABLE') q
WHERE p.table_name = q.table_name(+)
ORDER BY 5,4,1;
fanzhuli(cx范主力) 23:34:13
表名 分区类型 分区类型 分区键 有无子分区 子分区类型 子分区键
--------------------- -------- -------- ----------- ---------- ---------- --------
CS_BUSINESS_ACTION 主分区 RANGE ACTIONDATE 无子分区
INT_SPSYNC_LOG 主分区 RANGE CREATE_DATE 无子分区
CS_FRD_CONTROLSUBS 主分区 RANGE CTRLTIME 无子分区
CS_ACC_INVPRINTLOG 主分区 RANGE DOTIME 无子分区
CS_VIP_OAIRSERVRECORD 主分区 RANGE DT_OPRTIME 无子分区
CM_SUBS_STATUSCHGHIS 主分区 RANGE INTIME 无子分区
CS_
fanzhuli(cx范主力) 23:34:13
REC_RETURNMSG 主分区 RANGE INTIME 无子分区
CM_GROUP_MEMBER_LOG 主分区 RANGE RECDATE 无子分区
CS_CARDACTIVE_LOG 主分区 RANGE RECDATE 无子分区
CS_REC_ACCOUNT 主分区 RANGE RECDATE 无子分区
---------------- 10 --------------
CS_REC_AUTHINFO 主分区 RANGE RECDATE 无子分区
CS_REC_CHANGE 主分区 RANGE RECDATE 无子分区
CS_REC_CUSTINFO 主分区 RANGE RECDATE 无子分区
CS_REC_CUSTOMER 主分区 RANGE
fanzhuli(cx范主力) 23:34:14
CS_REC_PAYPLAN 主分区 RANGE RECDATE 无子分区
CS_REC_PAYTYPE 主分区 RANGE RECDATE 无子分区
CS_REC_PRODATTR 主分区 RANGE RECDATE 无子分区
CS_REC_PRODFEE 主分区 RANGE RECDATE 无子分区
CS_REC_PRODUCT 主分区 RANGE RECDATE 无子分区
CS_REC_PROPERTY 主分区 RANGE RECDATE 无子分区
CS_REC_PROTOCOL_LOG 主分区 RANGE RECDATE 无子分区
CS_REC_REASON 主分区 RANGE RECDATE 无子分区
fanzhuli(cx范主力) 23:34:14
RECDATE 无子分区
CS_REC_FORBID 主分区 RANGE RECDATE 无子分区
CS_REC_INDIVIDUAL 主分区 RANGE RECDATE 无子分区
CS_REC_ORDER 主分区 RANGE RECDATE 无子分区
CS_REC_ORDERDETAIL 主分区 RANGE RECDATE 无子分区
CS_REC_ORDERFEE
主分区 RANGE RECDATE 无子分区
CS_REC_ORDERINFO 主分区 RANGE RECDATE 无子分区
---------------- 20 --------------
CS_REC_ORDERLOG 主分区 RANGE RECDATE 无子分区
fanzhuli(cx范主力) 23:34:14
CS_REC_REFUNDMENT 主分区 RANGE RECDATE 无子分区
---------------- 30 --------------
CS_REC_RESOURCE 主分区 RANGE RECDATE 无子分区
CS_REC_WRTBLANKCARD 主分区 RANGE RECDATE 无子分区
OM_WF_ORDERLINELOG 主分区 RANGE RECDATE 无子分区
OM_WF_RECEPTION 主分区 RANGE RECDATE 无子分区
OM_WL_LOG 主分区 RANGE RECDATE 无子分区
OM_WL_WORKLISTATTR 主分区 RANGE RECDATE 无子分区
OM_WL_WORK
fanzhuli(cx范主力) 23:34:14
LISTATTRLOG 主分区 RANGE RECDATE 无子分区
liuni(cx刘妮) 00:11:51
CM_SUBS_SUBSCRIBER_LOG
liuni(cx刘妮) 00:26:04
backScorebizpreorderMain
fanzhuli(cx范主力) 00:44:44
SA_BSF_LOGINLOG
=========================================================
select OBJECT_NAME,SUBOBJECT_NAME,OBJECT_TYPE from user_objects
where OBJECT_NAME='CS_REC_PAYPLAN' and OBJECT_TYPE='TABLE PARTITION';
OBJECT_NAME SUBOBJECT_NAME OBJECT_TYPE
-------------- -------------- ---------------
CS_REC_PAYPLAN P201106 TABLE PARTITION
CS_REC_PAYPLAN P201107 TABLE PARTITION
CS_REC_PAYPLAN P201108 TABLE PARTITION
CS_REC_PAYPLAN P201109 TABLE PARTITION
CS_REC_PAYPLAN P201110 TABLE PARTITION
CS_REC_PAYPLAN P201111 TABLE PARTITION
CS_REC_PAYPLAN P201112 TABLE PARTITION
CS_REC_PAYPLAN P201201 TABLE PARTITION
CS_REC_PAYPLAN P201202 TABLE PARTITION
CS_REC_PAYPLAN P201203 TABLE PARTITION
---------------- 10 --------------
CS_REC_PAYPLAN P201204 TABLE PARTITION
CS_REC_PAYPLAN P201205 TABLE PARTITION
CS_REC_PAYPLAN P201206 TABLE PARTITION
CS_REC_PAYPLAN P201207 TABLE PARTITION
CS_REC_PAYPLAN P201208 TABLE PARTITION
CS_REC_PAYPLAN P201209 TABLE PARTITION
CS_REC_PAYPLAN P201210 TABLE PARTITION
CS_REC_PAYPLAN PMAX TABLE PARTITION
18 rows selected.
select OBJECT_NAME,SUBOBJECT_NAME,OBJECT_TYPE from user_objects
where OBJECT_NAME='CS_REC_UNFINISHED' and OBJECT_TYPE='TABLE PARTITION';
select a.HEADER_FILE,a.SEGMENT_NAME
from dba_segments a, dba_segments b
where a.HEADER_FILE=b.HEADER_FILE
and a.SEGMENT_NAME=b.SEGMENT_NAME
and a.SEGMENT_TYPE='TABLE PARTITION'
and a.OWNER='NGCRM_ZH'
and a.SEGMENT_NAME in (
'CM_BKJOB_HIS','CM_BKJOB_PARA_HIS','CM_CU_CUSTOMER_REGISTER_HIS','CM_CU_GROUPMEM_HIS','CM_CU_GROUP_HIS','CM_CU_TARIFFBALANCELOG','CM_CU_VIPCARD_HIS','CM
_GROUP_MEMBER_LOG','CM_GROUP_OUTNETMEM_LOG','CM_SUBS_AGREEMENT_HIS','CM_SUBS_EXPERIENCE_HIS','CM_SUBS_PAYBEHALF_LOG','CM_SUBS_PAYPLANHIS','CM_SUBS_PRODATTR_HIS','CM_SUBS_PRODUCT_HIS','CM_SUBS_RESOURCE_HIS','CM_SUBS_SERVICE_HIS','CM_SUBS_STATUSCHGHIS','CM_SUBS_TRANSFERLOG','CS_ACC_INVPRINTLOG','CS_BUSINESS_ACTION','CS_BUSI_ACTION_LOG','CS_CARDACTIVE_LOG','CS_FRD_CONTROLSUBS','CS_LOG_DETAILQRYPRINT','CS_LOG_KEYPATH','CS_LOG_PASSWORDREST','CS_LOG_PASSWORDRESTLOG','CS_LOG_PRODCONVERT_ERRMSG','CS_LOG_TRANSLOG','CS_REC_ACCOUNT','CS_REC_AUTHINFO','CS_REC_BILLMAIL','CS_REC_BLANKBATINSTALL','CS_REC_BRANDCHANGE','CS_REC_BRANDCHANGECHECKRESULT','CS_REC_CARDACTIVELOG','CS_REC_CHANGE','CS_REC_CHARGEREMIND','CS_REC_CHECKCREDITCARD','CS_REC_CUSTADDR','CS_REC_CUSTINFO','CS_REC_CUSTOMER','CS_REC_CUSTRELATION','CS_REC_CZK','CS_REC_DISCLOG','CS_REC_ESTOREDZESULT','CS_REC_ESTORELOG','CS_REC_FORBID','CS_REC_GROUP_MEMBER','CS_REC_GROUP_MEMBERPROD','CS_REC_GROUP_SUBSCRIBER','CS_REC_ICCIDAUTHLOG','CS_REC_INDIVIDUAL','CS_REC_INSTALLMENT','CS_REC_INVOICE','CS_REC_INVOICE_LOG','CS_REC_ORDER','CS_REC_ORDERBACK','CS_REC_ORDERDETAIL','CS_REC_ORDERFEE','CS_REC_ORDERINFO','CS_REC_ORDERLOG','CS_REC_PASSWORDRESETDETAIL_LOG','CS_REC_PASSWORDRESET_LOG','CS_REC_PAYPLAN','CS_REC_PAYTYPE','CS_REC_PRODATTR','CS_REC_PRODFEE','CS_REC_PRODSUBSCRIBER','CS_REC_PRODUCT','CS_REC_PROPERTY','CS_REC_PROTOCOL_LOG','CS_REC_QDCHECKRESULT','CS_REC_QRYCON','CS_REC_QRYCONHIS','CS_REC_QRYCON_HIS','CS_REC_REASON','CS_REC_RECIPIENT_LOG','CS_REC_REFUNDMENT','CS_REC_RESOURCE','CS_REC_RETFEE','CS_REC_RETFEESP','CS_REC_RETURNMSG','CS_REC_SETTLETYPE','CS_REC_SUBSATTR','CS_REC_SUBSSTATUS_CHANGE','CS_REC_SUBSSTATUS_CHANGE_HIS','CS_REC_SUBS_PROPERTY','CS_REC_TICKETPKGBOOK','CS_REC_TICKETPKGBOOKLOG','CS_REC_TICKETPKGFAILLOG','CS_REC_TICKETPKGFILEINFO','CS_REC_TICKETPKGFILEINFOHIS','CS_REC_UNFINISHED','CS_REC_URGEFEE','CS_REC_USER_PASSWORD_LOG','CS_REC_WLANPAUSERESUME','CS_REC_WORKRECRELA','CS_REC_WRTBLANKCARD','CS_SMS_WORKLISTHIS','CS_SP_SCORELOG','CS_SYS_RECONLOG','CS_VIP_OAIRSERVRECORD','GRP_VPMNUNITE_UPLOADLOG','IB_WL_BILLTABLOG','IM_WL_AIRNOREQHIS','IM_WL_AIRNOSIMREQHIS','IM_WL_CZOPR','IM_WL_CZREQHIS','IM_WL_DZCZREQHIS','IM_WL_EMPTYREQHIS','IM_WL_EMPTYSIMOPR','IM_WL_ENTITYCARDOPR','IM_WL_ENTITYCARDREQHIS','IM_WL_GIFOPR','IM_WL_GIFREQHIS','IM_WL_IMRESOPR','IM_WL_INPUTREQHIS','IM_WL_INVOPR','IM_WL_INVREQHIS','IM_WL_JFCARDOPR','IM_WL_JFCARDREQHIS','IM_WL_MOBILEOPR','IM_WL_MOBILEPRODCHG','IM_WL_MOBILEREQHIS','IM_WL_NORESPOOLLOG','IM_WL_OTHEROPR','IM_WL_OTHERREQHIS','IM_WL_PWDCARDHIS','IM_WL_RESLOG','IM_WL_SIMOPR','IM_WL_SIMREQHIS','IM_WL_SJOPR','IM_WL_SJREQHIS','IM_WL_SMPOPR','IM_WL_SMPREQHIS','IM_WL_VCARDACTIVE','INT_JF_CARDNOTIFYHIS','INT_MAP_BKRESULT','INT_SCOREREC_LOG','INT_SMS_SMNOTIFY_HISTORY','INT_SMS_SMNOTIFY_PARA','INT_SPSYNC_LOG','INT_TRANSLOG_LOG','INT_UF_LOG','INT_UF_SCHEDULE_LOG','INT_VIPSERVICE_LOG','INT_WRITECARD_LOG','MM_DET_PLWORKLOG','MM_MK_FRAME_LOG','MM_MK_PRODUTE_LOG','OM_WF_ADJUSTLOG','OM_WF
_ORDERLINELOG','OM_WF_ORDER_TRACK_HIS','OM_WF_PRODATTR','OM_WF_RECEPTION','OM_WF_RESOURCE','OM_WL_LOG','OM_WL_WORKLISTATTR','OM_WL_WORKLISTATTRLOG','PC_PP_BUSILOG','PC_PP_BUSILOGDETA','SA_ADM_LOG','SP_FB_RESULT'
)
order by 2
unload to 000
select a.*
from dba_segments a
where a.SEGMENT_TYPE='TABLE PARTITION'
and a.OWNER='NGCRM_ZH'
and a.SEGMENT_NAME in (
'CM_BKJOB_HIS','CM_BKJOB_PARA_HIS','CM_CU_CUSTOMER_REGISTER_HIS','CM_CU_GROUPMEM_HIS','CM_CU_GROUP_HIS','CM_CU_TARIFFBALANCELOG','CM_CU_VIPCARD_HIS','CM_GROUP_MEMBER_LOG','CM_GROUP_OUTNETMEM_LOG','CM_SUBS_AGREEMENT_HIS','CM_SUBS_EXPERIENCE_HIS','CM_SUBS_PAYBEHALF_LOG','CM_SUBS_PAYPLANHIS','CM_SUBS_PRODATTR_HIS','CM_SUBS_PRODUCT_HIS','CM_SUBS_RESOURCE_HIS','CM_SUBS_SERVICE_HIS','CM_SUBS_STATUSCHGHIS','CM_SUBS_TRANSFERLOG','CS_ACC_INVPRINTLOG','CS_BUSINESS_ACTION','CS_BUSI_ACTION_LOG','CS_CARDACTIVE_LOG','CS_FRD_CONTROLSUBS','CS_LOG_DETAILQRYPRINT','CS_LOG_KEYPATH','CS_LOG_PASSWORDREST','CS_LOG_PASSWORDRESTLOG','CS_LOG_PRODCONVERT_ERRMSG','CS_LOG_TRANSLOG','CS_REC_ACCOUNT','CS_REC_AUTHINFO','CS_REC_BILLMAIL','CS_REC_BLANKBATINSTALL','CS_REC_BRANDCHANGE','CS_REC_BRANDCHANGECHECKRESULT','CS_REC_CARDACTIVELOG','CS_REC_CHANGE','CS_REC_CHARGEREMIND','CS_REC_CHECKCREDITCARD','CS_REC_CUSTADDR','CS_REC_CUSTINFO','CS_REC_CUSTOMER','CS_REC_CUSTRELATION','CS_REC_CZK','CS_REC_DISCLOG','CS_REC_ESTOREDZESULT','CS_REC_ESTORELOG','CS_REC_FORBID','CS_REC_GROUP_MEMBER','CS_REC_GROUP_MEMBERPROD','CS_REC_GROUP_SUBSCRIBER','CS_REC_ICCIDAUTHLOG','CS_REC_INDIVIDUAL','CS_REC_INSTALLMENT','CS_REC_INVOICE','CS_REC_INVOICE_LOG','CS_REC_ORDER','CS_REC_ORDERBACK','CS_REC_ORDERDETAIL','CS_REC_ORDERFEE','CS_REC_ORDERINFO','CS_REC_ORDERLOG','CS_REC_PASSWORDRESETDETAIL_LOG','CS_REC_PASSWORDRESET_LOG','CS_REC_PAYPLAN','CS_REC_PAYTYPE','CS_REC_PRODATTR','CS_REC_PRODFEE','CS_REC_PRODSUBSCRIBER','CS_REC_PRODUCT','CS_REC_PROPERTY','CS_REC_PROTOCOL_LOG','CS_REC_QDCHECKRESULT','CS_REC_QRYCON','CS_REC_QRYCONHIS','CS_REC_QRYCON_HIS','CS_REC_REASON','CS_REC_RECIPIENT_LOG','CS_REC_REFUNDMENT','CS_REC_RESOURCE','CS_REC_RETFEE','CS_REC_RETFEESP','CS_REC_RETURNMSG','CS_REC_SETTLETYPE','CS_REC_SUBSATTR','CS_REC_SUBSSTATUS_CHANGE','CS_REC_SUBSSTATUS_CHANGE_HIS','CS_REC_SUBS_PROPERTY','CS_REC_TICKETPKGBOOK','CS_REC_TICKETPKGBOOKLOG','CS_REC_TICKETPKGFAILLOG','CS_REC_TICKETPKGFILEINFO','CS_REC_TICKETPKGFILEINFOHIS','CS_REC_UNFINISHED','CS_REC_URGEFEE','CS_REC_USER_PASSWORD_LOG','CS_REC_WLANPAUSERESUME','CS_REC_WORKRECRELA','CS_REC_WRTBLANKCARD','CS_SMS_WORKLISTHIS','CS_SP_SCORELOG','CS_SYS_RECONLOG','CS_VIP_OAIRSERVRECORD','GRP_VPMNUNITE_UPLOADLOG','IB_WL_BILLTABLOG','IM_WL_AIRNOREQHIS','IM_WL_AIRNOSIMREQHIS','IM_WL_CZOPR','IM_WL_CZREQHIS','IM_WL_DZCZREQHIS','IM_WL_EMPTYREQHIS','IM_WL_EMPTYSIMOPR','IM_WL_ENTITYCARDOPR','IM_WL_ENTITYCARDREQHIS','IM_WL_GIFOPR','IM_WL_GIFREQHIS','IM_WL_IMRESOPR','IM_WL_INPUTREQHIS','IM_WL_INVOPR','IM_WL_INVREQHIS','IM_WL_JFCARDOPR','IM_WL_JFCARDREQHIS','IM_WL_MOBILEOPR','IM_WL_MOBILEPRODCHG','IM_WL
_MOBILEREQHIS','IM_WL_NORESPOOLLOG','IM_WL_OTHEROPR','IM_WL_OTHERREQHIS','IM_WL_PWDCARDHIS','IM_WL_RESLOG','IM_WL_SIMOPR','IM_WL_SIMREQHIS','IM_WL_SJOPR','IM_WL_SJREQHIS','IM_WL_SMPOPR','IM_WL_SMPREQHIS','IM_WL_VCARDACTIVE','INT_JF_CARDNOTIFYHIS','INT_MAP_BKRESULT','INT_SCOREREC_LOG','INT_SMS_SMNOTIFY_HISTORY','INT_SMS_SMNOTIFY_PARA','INT_SPSYNC_LOG','INT_TRANSLOG_LOG','INT_UF_LOG','INT_UF_SCHEDULE_LOG','INT_VIPSERVICE_LOG','INT_WRITECARD_LOG','MM_DET_PLWORKLOG','MM_MK_FRAME_LOG','MM_MK_PRODUTE_LOG','OM_WF_ADJUSTLOG','OM_WF_ORDERLINELOG','OM_WF_ORDER_TRACK_HIS','OM_WF_PRODATTR','OM_WF_RECEPTION','OM_WF_RESOURCE','OM_WL_LOG','OM_WL_WORKLISTATTR','OM_WL_WORKLISTATTRLOG','PC_PP_BUSILOG','PC_PP_BUSILOGDETA','SA_ADM_LOG','SP_FB_RESULT'
)
order by PARTITION_NAME;