Tag Archives: partition
Oracle普通表->分区表转换(9亿数据量)
某普通表T，由于前期设计不当没有分区，如今几年来的数据量已达9亿+, 空间占用大约350G，在线重定义为分区表不现实，故采取申请时间窗口停此表应用，改造为分区表。 Continue reading
Categories
- AI (3)
- Cloud (16)
- OCI (8)
- VirtualBox (4)
- 蓝鲸智云 (4)
- DB (174)
- Greenplum (2)
- MySQL (15)
- Infobright (3)
- MySQL安装部署 (8)
- MySQL故障处理 (3)
- Oracle (150)
- New Features (1)
- Oracle SQL (1)
- Oracle一体机 (12)
- Oracle专项实施 (14)
- Oracle体系原理 (6)
- Oracle备份恢复 (11)
- Oracle安装部署 (23)
- Oracle性能优化 (10)
- Oracle故障处理 (27)
- Oracle日常运维 (27)
- Oracle最佳实践 (11)
- Oracle补丁应用 (8)
- Redis (1)
- TiDB (1)
- Vertica (6)
- Life+ (47)
- OS (28)
- Scripts (6)
Archives
- April 2024 (3)
- March 2024 (2)
- February 2024 (1)
- January 2024 (2)
- December 2023 (1)
- November 2023 (1)
- September 2023 (3)
- December 2022 (1)
- November 2022 (2)
- October 2022 (1)
- September 2022 (3)
- August 2022 (1)
- July 2022 (3)
- June 2022 (3)
- May 2022 (3)
- April 2022 (4)
- March 2022 (1)
- February 2022 (5)
- January 2022 (6)
- December 2021 (5)
- November 2021 (7)
- October 2021 (5)
- September 2021 (7)
- August 2021 (4)
- July 2021 (3)
- June 2021 (4)
- May 2021 (1)
- April 2021 (2)
- March 2021 (1)
- February 2021 (2)
- January 2021 (3)
- December 2020 (1)
- November 2020 (2)
- September 2020 (3)
- August 2020 (7)
- July 2020 (17)
- June 2020 (15)
- May 2020 (4)
- April 2020 (7)
- March 2020 (5)
- February 2020 (3)
- January 2020 (1)
- December 2019 (4)
- November 2019 (1)
- August 2019 (2)
- July 2019 (4)
- May 2019 (4)
- April 2019 (1)
- March 2019 (1)
- February 2019 (1)
- January 2019 (3)
- December 2018 (5)
- November 2018 (7)
- October 2018 (2)
- June 2018 (2)
- May 2018 (1)
- April 2018 (3)
- January 2018 (1)
- December 2017 (1)
- November 2017 (1)
- October 2017 (1)
- September 2017 (2)
- August 2017 (7)
- July 2017 (2)
- May 2017 (1)
- April 2017 (1)
- March 2017 (3)
- February 2017 (1)
- January 2017 (5)
- December 2016 (1)
- November 2016 (3)
- September 2016 (2)
- August 2016 (2)
- June 2016 (3)
- May 2016 (1)
- January 2016 (3)
- November 2015 (3)
- September 2015 (1)
- August 2015 (3)
- July 2015 (3)
- June 2015 (3)
- May 2015 (5)
- April 2015 (3)
- March 2015 (1)
- October 2014 (1)
- September 2014 (1)
- August 2014 (1)
- July 2014 (1)
- June 2014 (4)
- May 2014 (1)
-
Recent Posts
Tags
Alfred Zhao 在博客园
