Informatica Tutorials

Big Data Analytics

Partitioning and Subpartitioning Columns and Keys

The partitioning columns (or subpartitioning columns) of a table or index consist of an
ordered list of columns whose values determine how the data is partitioned or
subpartitioned. This list can include up to 16 columns, and cannot include any of the
following types of columns:

■ A LEVEL or ROWID pseudocolumn
■ A column of the ROWID datatype
■ A nested table, VARRAY, object type, or REF column
■ A LOB column (BLOB, CLOB, NCLOB, or BFILE datatype)

A row's partitioning key is an ordered list of its values for the partitioning columns.
Similarly, in composite partitioning a row's subpartitioning key is an ordered list of its values for the subpartitioning columns. Oracle applies either the range, list, or hash method to each row's partitioning key or subpartitioning key to determine which
partition or subpartition the row belongs in.

Related Posts Plugin for WordPress, Blogger...

Please Share

Twitter Delicious Facebook Digg Stumbleupon Favorites More

Follow TutorialBlogs
Share on Facebook
Tweet this Blog
Add Blog to Technorati