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
This article presents how to install Oracle 12C(12.1) Release 1 on Oracle Enterprise Linux 7 (OEL7) in silent mode.
This article presents simple method how you can estimate index size for CREATE REBUILD operation
In 12C LEFT OUTER JOIN is enhanced so a single table can be the null-generated table for multiple tables
This article presents how-to dump SQL as CSV files using PL/SQL
The most popular method to clone a schema in Oracle is impdp tool. It allows to clone one or many schema between databases or inside the same database.
Impdp tool is based on PL/SQL package DBMS_DATAPUMP. This article shows how to use the package and clone a schema using pure PL/SQL.
This article presents methods to check storage performance IOPS and MBPS in Oracle:
Oracle internal table SYS.USER$ has got many interesting columns for DBAs. This article describes some of them.
This presentation shows how to install and configure Oracle R Enterprise Client 1.5 for Oracle Database 12C Linux OEL6.
Architecture
Following picture shows general architecture of Oracle R. This article will focus only on installation of Client parts.
