Partitioning Tables  «Prev  Next»

Lesson 9

Oracle Partitioning Conclusion

This lesson covered the new features that Oracle has added to enhance and improve partitioning.
In this module, you learned how to:
  1. Partition an index-organized table
  2. Partition an object table
  3. Partition a table with LOBs
  4. Describe how to enable row movement in a partitioned table
  5. Rename, move, and coalesce partitions
  6. Exchange a partition with a table
  7. Describe how to create a partition-wise query or join


The following terms were defined in this module:
  1. Partitioning: Dividing one table into several sections, or partitions, which are physically stored as if each partition were a separate table.
  2. Index-organized table: A table that is stored in the database in physical order by its primary key.
  3. Row movement: The automatic shifting of a row from one partition to another when the value of the partitioning column in the row changes so that the row belongs in a different partition.
  4. Equipartitioned table: A partitioned table that has an index that is also partitioned in exactly the same way as the table.
  5. Parallel queries: Queries are divided into smaller sections, and each section of the query executes simultaneously (in parallel) in the database server. This is not the same as Oracle Parallel Server.
In the next module, you will learn about new Oracle features for Oracle Parallel Servers.