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.…

SecureFiles Lobs overview

Secure File LOBs was an Oracle 11g database new feature that provides faster access to unstructured data stored in LOB columns. Securefile Lobs have several benefits than traditional Lobs. In addition, it features data compression, encryption and data deduplication. SecureFiles supports advanced file system features such as: Deduplication – detecting identical securefile data, and storing…

Oracle 11G XE and the 11 gigabyte limit

Hello, I have been often been asked how the Oracle 11G XE database Storage limit works exactly. So I would just post an example here to clarify. Here’s an example: We create a tablespace where the limit exceeds 11 gigabytes and we get an ORA-12953: SQL> create tablespace appdata datafile ‚/u01/app/oracle/oradata/XE/appdata01.dbf‘ size 18G; create tablespace…