Managing partitioned tables

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


Related posts

Leave a Comment