Oracle Database 12c datapump export expdp has an option to export the views as tables. Expdp exports the view definition as a table and its data.

This is an extremely useful feature to export subset of data.

At import time, datapump creates the table with column name and data type similar to the view and performs the data load.

Grants and other dependent objects on the views are also exported.

When VIEWS_AS_TABLES option is specified in the expdp, Oracle implicit creates a table using the CREATE TABLE AS and populates with data.

Read more about this feature in the Oracle Documentation.

Yesterday, we discussed merging and splitting multiple partitions. The same feature is extended in 12c to add, drop or truncate multiple partitions in a single SQL statement.

Add multiple partitions example:

Read more in Oracle Documentation

 

Truncate multiple partitions example:

Read more in Oracle Documentation

 

Drop multiple partitions example:

Read more in Oracle Documentation

 

 

 

In Oracle11g, you can merge or split two partitions. This feature is enhanced in 12c to merge and split multiple partitions in a single SQL thus reducing the maintenance operations. When merging range partitions, they must be adjacent.

Merging Partitions Example:

If range partitions are merged, you may use the “TO” clause.

Read more about this feature and restrictions in Oracle Documentation.

Splitting Partitions Example:

Read more in Oracle Documentation

 

 

%d bloggers like this: