02 2023 档案

Oracle split partition and table compression
摘要：DECLARE V_BEGIN_DT DATE; IN_PART_TYPE VARCHAR2(30):= 'PM_MAX'; STR_PART_DT VARCHAR2(30); STR_DT VARCHAR2(30); BEGIN FOR I IN(SELECT TABLE_NAME,MAX(PAR 阅读全文
posted @ 2023-02-14 10:14 Ayumie 阅读(28) 评论(0) 推荐(0) 编辑
Oracle add partition by MONTH (Compress)
摘要：--add partition by MONTH (Compress) 20230213 --SELECT TABLE_NAME,PARTITION_NAME,COMPRESSION,T.* FROM USER_TAB_PARTITIONS T WHERE TABLE_NAME = 'TEST_CO 阅读全文
posted @ 2023-02-13 17:42 Ayumie 阅读(34) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示