|Lesson 4|| Partitioning enhancements|
|Objective|| Identify the features for partitioned tables.|
Oracle Partioned Tables
There are many features for partitioned tables
in Oracle that we have dedicated an entire module on the subject later in this course. For an introduction to these new features, navigate through the Carousel below.
- Sometimes a row's data is updated and the data no longer falls in the partitioning criteria for the partition that the row was inserted into.
- Occasionally, your original plan for partitioning a table results in an imbalance of distribution of data across the partitions.
- Once that is done, the old partitions (2 and 3) are automatically removed.
- How do you load data into one partition without having to rebuild all the partitions in the table? (See Table Partitioning Improvements below)
Oracle Block Size
The block size of the SYSTEM tablespace is the standard block size. This is set when the database is created and can be any valid size.
You can specify up to four block sizes, in addition to a standard block size. In the initialization file, you can configure subcaches within the buffer cache for each of these block sizes. Subcaches can also be configured while an instance is running. You can create tablespaces having any of these block sizes. The standard block size is used for the system tablespace and most other tablespaces.
Multiple block sizes are useful primarily when transporting a tablespace from an OLTP database to an enterprise data warehouse.
This facilitates transport between databases of different block sizes. The next lesson introduces the new features for connectivity.
A table containing data in multiple physical tables. This divides large amounts of data into smaller segments.