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:
- intelligent compression
- transparent decryption
- easier management and development
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 installation of new Oracle Enterprise Manager Cloud Control 13C release 2 (22.214.171.124) on Oracle Linux OEL6, OEL7.
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:
- ORION tool
Oracle internal table SYS.USER$ has got many interesting columns for DBAs. This article describes some of them.