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. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)