Partition:
- Range Partition
- Interval Partition (extension of Range Partition)
- List Partition
- Hash Partition
- Reference Partition
- Range-Hash Partition (Subpartition)
USER_TAB_PARTITIONS
USER_SEGMENTS
USER_PART_TABLES
DBA_TAB_PARTITIONS
USER_LOB_PARTITIONS
Database VLDB and Partitioning Guide -> 4 Partition Administration
https://www.youtube.com/watch?v=VBkpI4Ki49Q – Range Partition
https://www.youtube.com/watch?v=0YYXfFcbC-A – List Partition
https://www.youtube.com/watch?v=PrjI-aZrNZE – Hash Partition
https://www.youtube.com/watch?v=TT7aDwNFzC4 – Reference Partition
https://www.youtube.com/watch?v=BESXA-k5EJU – Virtual column
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)