RelationalDBDesign RelationalDBDesign



Partitioned Tables   «Prev  Next»
Lesson 11

Oracle Partitioning Tables Conclusion

Partitioning tables can help you to improve performance and reduce downtime and maintenance.
In this module, you learned about partitioning tables and indexes. You learned:
  1. Reasons for partitioning
  2. Advantages of partitioned tables
  3. How to partition on a range of values
  4. How to index a partitioned table
  5. The differences between local and global indexes
  6. How to merge, split and drop partitions

Glossary

In this module you were introduced to the following terms:
  1. Dump file: The dump file set is made up of one or more disk files that contain table data, database object metadata, and control information. The files are written in a binary format. During an import operation, the Data Pump Import utility uses these files to locate each database object in the dump file set.
  2. RAID disk arrays: RAID (redundant array of independent disks) is a data storage virtualization technology that combines multiple physical disk drive components into a single logical unit for the purposes of data redundancy, performance improvement, or both
More terms from the Extended Database Features glossary can be located here . In the next module you will learn about clustering tables and indexes.

Oracle Partition - Quiz

Before moving on, click the Quiz link below to answer some final questions about modifying partitions.
Oracle Partition - Quiz