This frequently asked question comes in several variants, including:
- Can I use Oracle GoldenGate with EBS on-premises to set up an operational reporting environment in Oracle Cloud?
Can I use Oracle GoldenGate Cloud Service with EBS?
- Can I use Oracle GoldenGate to replicate my EBS database to Oracle Cloud?
- Can I use Oracle GoldenGate to perform a live migration of my EBS database from on-premises to Oracle Cloud?
We will answer each question in turn. (more...)
Since its release in 10gR1, Oracle have consistently added neat functionality to the “new” scheduler with every database release. Yes, I still call it the new scheduler and you would be surprised how many people still insist on using DBMS_JOB rather than switching to DBMS_SCHEDULER.
Oracle Database 12c Release 2 (12.2) is no exception to this pattern, as once again we have some new stuff to play with.
This is the second blog about new partitioning functionality in Oracle
Database 12c Release 2, available on-premise for Linux x86-64, Solaris Sparc64, and Solaris x86-64 and for everybody else in the Oracle Cloud .
This one will talk about multi column list partitioning, a new
partitioning methodology in... [Read More
Very often, significant performance benefits can be obtained by using some very basic knowledge of the application, its data and business rules. Sometimes even less than that: even if you are not familiar with the application logic at all, you can still use common sense to make some reasonable guesses that would get you a long way in improving query’s performance. Here is an example (based on an actual query that I had to tune (more...)
Node-oracledb 1.13.0, the Node.js add-on for Oracle Database, is on
Top node-oracledb feature: a fetchAsBuffer mode for fetching BLOBs.
A side note: Oracle Database 12.2 is also here! And Oracle Instant Client 12.2 is available too. Node-oracledb works
with 12.2 client libraries (as well as 11.2 and 12.1). ... [Read More
I received a question from 3 different colleagues in the past week:
"Does Oracle Database 12.2 still allow us to create non-CDB databases?"
And as I get this question at every customer-facing workshop these days as well before being able to talk about Single/Multitenant - I think it is important to... [Read More
If you follow me on social media, you will know I’ve put out a few 12cR2 installation articles recently. It’s good motivation for me to read through the installation guides and see what’s changed, if anything, between versions. I quite like doing some of this nuts & bolts stuff.
If you’re interested, this is what I’ve done so far.
If you are anything like me you will have multiple virtualboxes running on your system. Sometimes you might want to run a copy of a virtualbox for different purposes. Like running an Oracle 11 Devdays instance as test environment but also running the same vbox for customer testing. If you copy the vbox and try to run it in the manager you’ll be presented with an error that a harddisk with the same UUID already (more...)
Today we are pleased to announce the release of cx_Oracle 5.3, the
extremely popular Python interface for Oracle Database. Binary and
source bundles can be installed from PyPi, as normal.
cx_Oracle 5.3 works with Python version 2.7, and with versions 3.4
and higher. You can use cx_Oracle with Oracle 11.2, 12.1 and... [Read More
Somebody asked me the other day why the download options for Oracle Database 22.214.171.124 for Linux and Solaris disappeared from OTN?
The same will happen with the other platforms as soon as Oracle Database 126.96.36.199 is available on-premises for them as well.
You can always download Oracle Database 188.8.131.52... [Read More
Recently, I was trying to setup TDE. Doing that I found out the Oracle provided documentation isn’t overly clear, and there is a way to do it in pre-Oracle 12, which is done using ‘alter system’ commands, and a new-ish way to do it in Oracle 12, using ‘administer key management’ commands. I am using version 184.108.40.206.170117, so decided to use the ‘administer key management’ commands. This blogpost is about an (more...)
2 customers requested a bit more explanation on how to:Convert and Plugin an Oracle 12.1 non-CDB database into an Oracle 12.2 container database
Cool, I like that I will do this right away and use the approach to Upgrade first, then Plugin afterwards..
Upgrading an Oracle 220.127.116.11 database to Oracle 18.104.22.168
... [Read More
excited about the Exam Prep Seminar Packages! Here's why; we added a FREE retake voucher if you fail your exam, we lowered the pricing and we think they
offer a great value.
But most important is
what you think. Want to see what they’re like? Preview the Java SE 8 Programmer I
You can purchase the seminar all by itself. They are 4-6 hours in length and recorded by a great Oracle instructor (more...)
In the previous part (you can find it here) I discussed the character sets Oracle supports and the length limits. In this part I’ll show how it is actually stored and discuss some more topics that are relevant to using different languages with Oracle. Seeing the Data In order to see how Oracle saves the data, … Continue reading Using Different Languages in Oracle – Part 2
I did blog several times about how to remove an unwanted component from a database. But yesterday I came across this interesting scenario worth a blog post..
How to install a component afterwards in Single-/Multitenant?
I haven't checked all the MOS Notes but I recognized that some MOS Notes explaining how to... [Read More
We missed to document some functionality !!!
With the next milestone for Oracle Database 12c Release 2 just taking place - the
availability on premise for Linux x86-64, Solaris Sparc64, and
Solaris x86-64, in addition to the Oracle Cloud - I managed to use this as an excuse to play around with
it for a bit .. and... [Read More
Remember my post about Oracle 12.2 release date? I’ve heard rumors that Oracle changed the date to March 1st, and it was right! Oracle 12.2 is available for download for Linux x86-64, and Solaris (both SPARC and x86-64). I don’t know the release dates for other platforms. This is the download page: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html I’m downloading … Continue reading Oracle 12.2 is Released!
This is how I dump data from an Oracle Database (tested on 8i,9i,10g,11g,12c) to a delimited ascii file:
SQL*Plus: Release 22.214.171.124.0 Production on Fri Feb 24 13:55:47 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Oracle Database 12c Standard Edition Release 126.96.36.199.0 - 64bit Production
SQL> set timing on
SQL> select Dump_Delimited('select * from all_objects', 'all_objects.csv') nr_rows from dual;