News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Oracle 12c New Feature IDENTITY Columns

  • Posted by Gavin Soorma
  • On November 12, 2014
  • 0 Comments
In Oracle 12c when we create a table we can populate a column automatically via a system generated sequence by using the GENERATED AS IDENTITY clause in the CREATE TABLE statement. We can use GENERATED AS IDENTITY with the ALWAYS, DEFAULT or DEFAULT ON NULL keywords and that will affect the way or when the […]
Read More
 

Oracle 12c new feature In-Database Archiving

  • Posted by Gavin Soorma
  • On August 5, 2013
  • 0 Comments
Very often in our databases we have some very large tables which have a lot of historical and legacy data and the challenge is deciding what is old data and what is current data and even if we do identify the old data we do not need and have moved that data to tape storage, […]
Read More
 

Oracle12c database creation using DBCA

  • Posted by Gavin Soorma
  • On June 28, 2013
  • 0 Comments
In an earlier post we had discussed the installation process of the Release 12.1 Oracle database software and highlighted a few differences we can get to notice in some of the screens. Let us now look at the creation of an Oracle 12c database using the Database Configuration Assistant DBCA and briefly discuss what is […]
Read More