Receive targeted exam preparation delivered by Oracle’s top instructors with Exam Prep Seminar recordings. Stop, replay or fast forward over each exam objective as needed. Each seminar is delivered in a video streaming format, available 24/7 enabling you to watch as often as you want during the six month subscription term.
Available as Exam Prep Seminar Packages or Exam Prep Seminar – recordings ONLY.
Exam Prep Seminar Packages include:
One requirement of Transportable Tablespaces (and of course Full Transportable Export/Import as well) is to have identical database character sets AND identical time zone settings.
Source database has a lower time zone setting than the default target database in the destination home.
Lets assume you'd... [Read More
A few weeks ago the 12.2 Oracle Database was released on the cloud. I immediately set an account and got my 12.2 DBaaS setup. This was a relatively painless process and quick.
For me I wanted to test out all the new Oracle Advanced Analytics new features and the new features in SQL Developer 4.2 that only become visible when you are using the 12.2 Database.
When you are go to (more...)
The workshops in Brussels and Utrecht were awesome with great audience - I enjoyed both events a lot. And thanks for your patience with my voice and the microphone issues we've had in Brussels before lunch.
I promised the workshop slides - and here they are, ready for download:
Upgrade, Migrate and Consolidate to... [Read More
A preview of node-oracledb 1.12.0-dev is available on GitHub and can be installed with:
npm install oracle/node-oracledb.git#v1.12.0-dev
Node-oracledb is the Node.js add-on for Oracle Database.
The key things to look at are all the LOB enhancements - we want feedback. There are a couple more LOB
enhancements... [Read More
#DOAG2016, the largest Oracle Community gathering in Europe. Taking place in Nuremberg, at the Nuremberg Convention Center NCC, one of the more impressive places to hold such a conference, towering 4 stories high, with a big central atrium!!
It is a huge effort to get all of this together!
In this blog-post I want to highlight some of the crazy things I experienced this week… And… I did try to follow my own schedule (more...)
In my last post, I walked you through the first part of installing the Oracle Database 12c STIG compliance standards sample code. The next step to using these compliance standards is to associate your Oracle Database 12c databases with these standards. You may recall there are two separate standards in the sample code, one for multitenant databases and the other for conventional architecture databases. The process of associating the databases is the same in (more...)
We are posting these blog posts today as part of the OTN Appreciation Day, a celebration for the Oracle Technology Network as suggested by Tim Hall, inspired by Debra Lilley.
The mission was not too hard: write about your favorite bit of Oracle Technology.
As a developer and a core-tech DBA and APEX enthusiast… the choice was easy! PL/SQL (apart from how it is pronounced or even written ;-)!
Not just because (more...)
Thanks Tim for coming up with this idea! Pretty neat… And THANK YOU OTN!! There are quite a few features I like in the Oracle Database, but today I choose ORAchk (and EXAchk). Troubleshooting and diagnostics are my favorite area and I was amazed by the enhancements Oracle made in integrating the various diagnostics tools and preserving […]
In this post I just wanted to highlight a few things that have lingered with me since the 2016 Oracle Open World Experience.
Now, here, being at home, I must admit that I cannot find very much documentation about this, but it got me thinking… A little paradigm-shift, where computers actually wouldn’t need moving parts anymore (ie. disks of any kind). Create devices that use these memory structures, quite possibly combined with flash-disks, (more...)
As many conferences evolve over the years, the number of sessions on offer can easily be overwhelming. I have overheard many conference attendees wrestling with their choices for what to see and which sessions to attend.
For DOAG 2016 I have a short overview with my picks and with one or two tip-sessions. I hope this helps, though it is just my personal preference of course…
Please note that this post is based on the (more...)
The next major release of the Oracle Database has always been a big thing. Last year at Oracle OpenWorld , a lot of sessions were dedicated to Release 2 of Oracle Database 12c – with sharding as probably its most eye catching new feature. Talk of the release date started at once. June 2016 was a popular date in these talks. June came and went. And now, come Oracle OpenWorld 2016, R2 is out – (more...)
One of the most requested features in the compliance management area has been a compliance standard for Oracle Database 12c. As most of you would know, Oracle Database 12c has been out for quite some time, and indeed Larry Ellison has just announced at OOW2016 availability of Oracle Database 12cR2 in Oracle’s public cloud offering. However, as I discussed in another post earlier this year, creating a new STIG compliance standard is not a simple (more...)
A brief headsup for everyone responsible for maintaining kernel options in the oracle executable.
The environment where I discovered this is a 3 node racattack cluster with Oracle GI & RDBMS 126.96.36.199.0. After enabling Unified auditing in my 188.8.131.52 database I noticed that all of a sudden database startup started failing with an almost unlimited amount of core dump files being generated.
SQL*Plus: Release 184.108.40.206. (more...)
For later creation of containers as needed in the deployment process we have first to build docker images whenever we do not find suitable one in docker hub.
For most of my development I need a oracle database. On the internet you can find a lot of Dockerfile’s for this, but no ready image. This is because for running a database you have to accept a license and this happens when you download the installation (more...)
This year, 2016, is turning out to be an amazing year again, with #OOW16 being once again on of the apices!
After the discovery of the Oracle community in 2012, as a result of a very first trip to downtown San Francisco in 2010 for #OOW10, an amazing chain of events was set in motion. This very first introduction in the Oracle World was as ‘a mere participant’ in this awe-inspring, large (more...)
Last week we were struck by an issue, which turned out to be a bite from a bug!
SYSAUX table-space had quickly filled up to the “my data-file is full”-limit, which in the end was fixed by adding a data-file.
Strange thing though, that for a very small footprint database, we now have a very big SYSAUX table-space.
Some investigation brought me to the Unified Auditing being standard active in database 12c (you can read (more...)
I bumped into this issue recently which prevents you INSERTING a date of 31-12-9999 into an INTERVAL partitioned table due to the fact that the LESS THAN partition value would be larger than an Oracle Date. After speaking with Jeff Moss he mentioned that we might be able to get round the problem by using a virtual
This script is used to set up the test table for the following blog posts: Oracle Database INTERVAL Partitioning Date Error With 31-12-9999 Oracle Database INTERVAL Partitioning and Virtual Columns [crayon-578913d2a047f830082062/]