12c New Feature: SQL Row-Limiting Clause

Its not realy a new feature because many other database vendors have this feature already but it is new to Oracle 12c. You can now limit the Output of rows in a SQL Query. A small example: Check the employees Table SQL> select count(*) from employees;   COUNT(*) ———-       107 Now we are only…

New preinstall package for 12cR1

Oracle has also released a new preinstall RPM package for Linux. You can install it with yum: [root@# etc]# yum install oracle-rdbms-server-12cR1-preinstall.x86_64 The Package has this dependency: Dependencies Resolved =====================================================================================================================================================================================  Package                                                      Arch                           Version                                        Repository                          Size ===================================================================================================================================================================================== Installing:  oracle-rdbms-server-12cR1-preinstall                         x86_64                         1.0-8.el6                                      ol6_latest                          15 k Installing for dependencies:  cloog-ppl                                                    x86_64                         0.15.7-1.2.el6                                 ol6_latest                          93 k  compat-libcap1                                               x86_64                         1.10-1                                        …

Clone a PDB

When you want to clone a PDB (in the same CDB) then there few simple steps to do. Check your Database Parameters Connect to your CDB Stop the source PDB (hope this step will not be necessary in future releases) Clone the PDB Open the PDB Step 1: Check your Database Parameters We want to…

Convert a non PDB to a PDB

When you want to convert a Single Instanz (non PDB) to a PDB (for example after a pre 12c Database upgrade) then this example is usefull for you. First here is a overview of the task: Open the database in read only mode Create a xml File for the conversion Login into your CDB Plug…

Oracle released 12c Database

Today Oracle has released the 12.1.0.1 Oracle Database. The Software is avaible for download from the OTN here. In the moment you can download the software for Linux 64Bit, Oracle Solaris 64Bit Sparc and x86-64. The first read in the license information, Oracle Plugable Database is only avaible in Enterprise Edition as extra cost option.…

Advanced Security Option als Standard in der 12C EE?

Hallo, hab auf Timur Akhmadeev Blogs eine interessante Information erfahren. Es klingt als wäre die Advanced Security Option Standard in der 12C Datenbank Release. Wenn dem so ist, sollten diejenigen welche gerade planen diese zu erwerben noch etwas warten. Zitat:Advanced Security will be free in the next release. Different ways to encrypt: tablespace, column, backup……