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.
This presentation shows how to install and configure Oracle R Enterprise Server 1.5 on Oracle 12C Linux OEL6.
Architecture
Following picture shows general architecture of Oracle R. This article will focus only on installation of Server parts.
This presentation shows how to install and configure Oracle R Enterprise Client 1.5 for Oracle Database 11G Linux OEL6.
Architecture
Following picture shows general architecture of Oracle R. This article will focus only on installation of Client parts.
This article presents installation of Oracle database 12C(12.1) on Fedora 24. Read following article to install Fedora 24 Linux: Install Fedora 24(for comfort set 4G memory for your virtual machine). Continue reading
This article presents how to install Fedora 24 – Live Workstation version.
I assume you have already downloaded Fedora 24 64 bit Live Workstation(about 1,4 G) and you know how to use VirtualBox 64 bit(100M). Create virtual machine with default settings for Linux Fedora 64 bit. 4GB ram and 64G(includes extra space and memory for Oracle installations) for disk is enough plus increase video memory to 128M. Rest of options you can keep default.
This article presents simple methods to write or read CLOB to/from file using following packages:
This article presents solution for “KUP-04026: field too long for datatype” for external tables. Usually it happens when you want to read data for CLOB columns.