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:
- Reasons for partitioning
- Advantages of partitioned tables
- How to partition on a range of values
- How to index a partitioned table
- The differences between local and global indexes
- How to merge, split and drop partitions
In this module you were introduced to the following terms:
- 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.
- 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.