A new pre-built VirtualBox image is available for download  from OTN (updated on March 27, 2017).

Once you download, import and configure the VM, you can pretty much do whatever you want. But Roy and Mike have put together a very good lab environment and exercise for you to practice Oracle database upgrade from 11gR2 to 12cR2. The lab includes

  • Manual upgrade of 11.2.0.4 database to 12.2.0.1
  • Attach 12c non-container database as a PDB to existing 12.2.0.1 CDB
  • Upgrade 11.2.0.4 database using Full Transportable Export/Import to 12.1.0.2 as a PDB
  • Upgrade 12.1.0.2 PDB to 12.2.0.1 using unplug / plug method

The pre-built VM comes with Oracle software already installed.

  • 11gR2 11.2.0.4 – /u01/app/oracle/product/11.2.0.4
  • 12cR1 12.1.0.2 – /u01/app/oracle/product/12.1.0.2
  • 12cR2 12.2.0.1 – /u01/app/oracle/product/12.2.0.1

Practice upgrades, new features, patches, PSU, migration using this VirtualBox image.

Thanks to Mike Dietrich and Roy Swonger!

VirtualBox Download

12c Database Image Download

 

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

 

 

 

%d bloggers like this: