Tag Archives: partition
Oracle普通表->分区表转换(9亿数据量)
某普通表T，由于前期设计不当没有分区，如今几年来的数据量已达9亿+, 空间占用大约350G，在线重定义为分区表不现实，故采取申请时间窗口停此表应用，改造为分区表。 Continue reading
Categories
- AI (6)
- Cloud (16)
- OCI (8)
- VirtualBox (4)
- 蓝鲸智云 (4)
- DB (183)
- Greenplum (2)
- MySQL (15)
- Infobright (3)
- MySQL安装部署 (8)
- MySQL故障处理 (3)
- Oracle (158)
- New Features (4)
- Oracle SQL (1)
- Oracle一体机 (13)
- Oracle专项实施 (14)
- Oracle体系原理 (6)
- Oracle备份恢复 (11)
- Oracle安装部署 (24)
- Oracle性能优化 (11)
- Oracle故障处理 (28)
- Oracle日常运维 (27)
- Oracle最佳实践 (11)
- Oracle补丁应用 (8)
- Redis (1)
- TiDB (1)
- Vertica (6)
- Life+ (50)
- OS (29)
- Scripts (6)
Archives
- November 2024 (1)
- October 2024 (1)
- September 2024 (1)
- August 2024 (2)
- July 2024 (1)
- June 2024 (4)
- May 2024 (4)
- 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 在博客园- Exadata系列之配置利器OECA - AlfredZhao
- Oracle的用户如何优雅地达成软件合规目标 - AlfredZhao
- 英语疑问句倒装特征以及从句的正常语序 - AlfredZhao
- 搞懂英语的五大基本句型 - AlfredZhao
- 使用触发器来审计表的DML、DDL操作 - AlfredZhao
- MongoDB安装、基础操作和聚合实例详解 - AlfredZhao
- Operational Property Graphs到底是个啥？ - AlfredZhao
- YUM退役了？DNF本地源配置 - AlfredZhao
- 实现并发新高度：23ai的无锁列值保留 - AlfredZhao
- Oracle优化神技之临时表 - AlfredZhao
