ilmarkerm.blogspot.com
Ilmar Kerm DB blog - blog address has changed -: July 2014
http://ilmarkerm.blogspot.com/2014_07_01_archive.html
Ilmar Kerm DB blog - blog address has changed -. THIS BLOG IS NO LONGER UPDATED NEW ADDRESS IS https:/ ilmarkerm.eu/. Friday, July 25, 2014. Database upgrade using pluggable databases and how catctl.pl fails if you have custom login.sql. I'm starting with these already created databases:. U01/app/oracle/product/12.1.0.1/db. The initial container with version 12.1.0.1. It is hosting the pluggable database DB1 that contains my application data. U01/app/oracle/product/12.1.0.2/db. Sys@cdb1(cdbtest.aws&#...
ilmarkerm.blogspot.com
Ilmar Kerm DB blog - blog address has changed -: Setting up SQL Developer with Instant Client on MacOSX
http://ilmarkerm.blogspot.com/2015/03/setting-up-sql-developer-with-instant.html
Ilmar Kerm DB blog - blog address has changed -. THIS BLOG IS NO LONGER UPDATED NEW ADDRESS IS https:/ ilmarkerm.eu/. Sunday, March 22, 2015. Setting up SQL Developer with Instant Client on MacOSX. Jan Karremans just today published a similar article about Mac and Instant client. But the goal of my blog post is to get SQL Developer connected through Instant Client. There is another reason to choose SQL Developer 4.0 over 4.1 - 4.1 requires version 12.1 of the Oracle Client and that is not...Open SQL Deve...
ilmarkerm.blogspot.com
Ilmar Kerm DB blog - blog address has changed -: April 2013
http://ilmarkerm.blogspot.com/2013_04_01_archive.html
Ilmar Kerm DB blog - blog address has changed -. THIS BLOG IS NO LONGER UPDATED NEW ADDRESS IS https:/ ilmarkerm.eu/. Tuesday, April 23, 2013. Sample code: Using Datapump API for metadata and data filtering. I was looking for PL/SQL examples to use metadata and data filtering in datapump API, but I didn't find any. So here is one example. It uses table reload dev tables to specify what schemas/tables should be exported using data pump and what where clause should be set. Structure for reload dev tables:.
ilmarkerm.blogspot.com
Ilmar Kerm DB blog - blog address has changed -: Putting Data Guard traffic on dedicated network interface
http://ilmarkerm.blogspot.com/2015/07/putting-data-guard-traffic-on-dedicated.html
Ilmar Kerm DB blog - blog address has changed -. THIS BLOG IS NO LONGER UPDATED NEW ADDRESS IS https:/ ilmarkerm.eu/. Sunday, July 19, 2015. Putting Data Guard traffic on dedicated network interface. The following tasks need to be completed:. Configure a new network interface in OS. I'm not going to discuss it here, but it is a prerequisite for any tasks to be done in Oracle. RAC needs special attention and it is described in this blog post. Now lets look at the properties of one of the databases. Each d...
ilmarkerm.blogspot.com
Ilmar Kerm DB blog - blog address has changed -: March 2015
http://ilmarkerm.blogspot.com/2015_03_01_archive.html
Ilmar Kerm DB blog - blog address has changed -. THIS BLOG IS NO LONGER UPDATED NEW ADDRESS IS https:/ ilmarkerm.eu/. Sunday, March 22, 2015. Setting up SQL Developer with Instant Client on MacOSX. Jan Karremans just today published a similar article about Mac and Instant client. But the goal of my blog post is to get SQL Developer connected through Instant Client. There is another reason to choose SQL Developer 4.0 over 4.1 - 4.1 requires version 12.1 of the Oracle Client and that is not...Open SQL Deve...
ilmarkerm.blogspot.com
Ilmar Kerm DB blog - blog address has changed -: October 2014
http://ilmarkerm.blogspot.com/2014_10_01_archive.html
Ilmar Kerm DB blog - blog address has changed -. THIS BLOG IS NO LONGER UPDATED NEW ADDRESS IS https:/ ilmarkerm.eu/. Wednesday, October 29, 2014. Structured XML output from Oracle SQL query. Got an interesting question today: There are tables TABLE1, TABLE2 and a junction table that joins them called JUNCTABLE. Need the following output as XML. I know the output could be aggregated using XMLAGG, but I have never looked into how to format the tag names and attributed in the output like requested. This po...
ilmarkerm.blogspot.com
Ilmar Kerm DB blog - blog address has changed -: Sample code: Using the Oracle ZFS Storage Appliance REST API from Python
http://ilmarkerm.blogspot.com/2014/12/sample-code-using-oracle-zfs-storage.html
Ilmar Kerm DB blog - blog address has changed -. THIS BLOG IS NO LONGER UPDATED NEW ADDRESS IS https:/ ilmarkerm.eu/. Sunday, December 28, 2014. Sample code: Using the Oracle ZFS Storage Appliance REST API from Python. This script exposes four tasks:. Creates a new clone from replication. Attaches all LUNs in a project to a single target server. Attaches all LUNs in a project to multiple target servers. ZFSSA REST API works fine if each LUN has only a single initiator group, but when assigning LUN to mul...
ilmarkerm.blogspot.com
Ilmar Kerm DB blog - blog address has changed -: August 2014
http://ilmarkerm.blogspot.com/2014_08_01_archive.html
Ilmar Kerm DB blog - blog address has changed -. THIS BLOG IS NO LONGER UPDATED NEW ADDRESS IS https:/ ilmarkerm.eu/. Friday, August 29, 2014. DBMS UTILITY.EXPAND SQL TEXT and temporal validity in 12c. First I'll create a table for testing with two periods - VALID and ACTIVE. VALID is using DATE datatype and ACTIVE is using hidden TIMESTAMP columns. First syntax that can be used to query temporal data is select id, t from temporal AS OF PERIOD FOR valid *TIMESTAMP*. Declare c clob; begin DBMS UTILITY....
ilmarkerm.blogspot.com
Ilmar Kerm DB blog - blog address has changed -: 12c metadata only default values for NULL columns
http://ilmarkerm.blogspot.com/2014/08/12c-metadata-only-default-values-for.html
Ilmar Kerm DB blog - blog address has changed -. THIS BLOG IS NO LONGER UPDATED NEW ADDRESS IS https:/ ilmarkerm.eu/. Monday, August 18, 2014. 12c metadata only default values for NULL columns. Before 11g if you added a new column to a table then Oracle had to lock and physically update all rows in the table. Possibly a painful process :) 11g helped with that a little, giving metadata only default values for NOT NULL columns, so the change was done only in data dictionary, not in the table data.
SOCIAL ENGAGEMENT