Enhanced CAST Function With Error Handling Oracle Database 12C release 2 (12.2)

Posted on January 17, 2017 by joda3008

CAST function in release 12.2 enables to add error handler DEFAULT return_value ON CONVERSION ERROR in case conversion fails.

Description of GUID-0711298C-420A-42CD-85DE-764C72183572-print.eps follows

Continue reading →

Long identifiers Oracle Database 12C release 2 (12.2)

Posted on January 17, 2017 by joda3008

New release 12.2 introduces possibility to generate long identifiers up to 128 characters for name like tables, views, triggers, columns and so on. In previous release it was limited to 30 characters.

Continue reading →

Install Oracle 12C Release 1 (12.1) on Fedora 25

Posted on December 20, 2016 by joda3008

This article presents installation of Oracle database 12C(12.1) on Fedora 25. Read following article to install Fedora 25 Linux: Install Fedora 25(for comfort set 4G memory for your virtual machine). Continue reading →

Install Fedora 25

Posted on December 16, 2016 by joda3008

This article presents how to install Fedora 25 – Live Workstation version.

I assume you have already downloaded Fedora 25 64 bit Live Workstation(about 1,3 G) and you know how to use VirtualBox 64 bit(100M). Create virtual machine with default settings for Linux Fedora 64 bit. 2GB ram and 64G(includes extra space for Oracle installations) for disk is enough plus increase video memory to 128M. Rest of options you can keep default.

Continue reading →

Oracle Advanced Transparent Data Encryption (TDE) in Oracle 11g Database Release 2

Posted on December 13, 2016 by joda3008

Oracle Advanced Transparent Data Encryption (TDE) is used for encrypting sensitive data on storage data for Oracle database. The encryption is totally transparent for application. TDE was introduced in 10G enabling encryption of a columns in 11G it was enhanced with encryption for tablespaces.

Continue reading →

Oracle SecureFile LOBs in 11G – Oracle Database 11G release 2 (11.2)

Posted on December 2, 2016 by joda3008

This article describes new feature of 11g SecureFile LOB.

In new version 11g Oracle decided to create new type large objects (LOB) called Secure Files. It offers many new benefits versus old version of LOB called in 11g release BasicFile:

performance
intelligent compression
transparent decryption
easier management and development

Continue reading →

ORA-22992, ORA-64202 cannot use LOB locators selected from remote tables

Posted on December 2, 2016 by joda3008

If you want try to select CLOB column via database link then you get error ORA-22992

select * from <TABLE_NAME>@<DATABASE LINK>;

ORA-22992: cannot use LOB locators selected from remote tables
22992. 00000 -  "cannot use LOB locators selected from remote tables"
*Cause:    A remote LOB column cannot be referenced.
*Action:   Remove references to LOBs in remote tables.

This article shows how to avoid this error

Continue reading →