From the course: Oracle Database 12c: Advanced SQL
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Introduction to partitioning - Oracle Database Tutorial
From the course: Oracle Database 12c: Advanced SQL
Introduction to partitioning
- [Instructor] Table partitioning in Oracle allows a database table to be subdivided into smaller pieces or elements. Each piece of that table is known as a table partition or just partition in short. Each table partition has it's own name and is technically a separate physical and logical database objects. However, from the perspective of the application a partition table is pretty much identical to a non-partition table. The benefits of the table being partitioned which we'll learn about in our next chapter all occur under the hood. So no modifications are necessary when your applications are exiting a partition table using sequel queries or DML statements. Note that when you partition your tables we split the tables horizontally, so all columns defined in our table remain for each individual table partition. It's the rows that are different per partition, not the columns. When creating a partition table you choose the table partitioning key. This is the column or columns with which…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.