-
Continue reading →: UKOUG Tech17 Call For Papers!
The UK OracleUser Group has opened its Call For Papers for our flagship conference. We are looking for presenters across all Oracle technologies – and non-Oracle Open Source tech too! Showcase your skills in front of a thousand technologists of all skill levels and experience. Do you have a story?…
-
Continue reading →: GoldenGate unsupported types
When using GoldenGate there are few rules which need to be followed, and a very small number of unsupported datatypes. This is the excerpt from the GoldenGate 12.2 manual: 1.6.10 Non-Supported Oracle Data Types Oracle GoldenGate does not support the following data types. ANYDATA fetch-based column support for…
-
Continue reading →: Getting Started with GoldenGate
Not a blog post per-se, but a link to my article in the UKOUG quarterly magazine OracleScene. It is a great publication with some simply fantastic articles. Its completely free, and is available online as well as in print at Oracle offices in the UK and at UKOUG events. My…
-
Continue reading →: SAN Migration and moving files with ASM
Here’s a quick post to help with LUN, SAN or File migration when using Oracle ASM. Please note that this is just an example method, and is not a definitive guide. You need to ensure your approach is appropriate for your environment. Did you know that you can add and…
-
Continue reading →: UKOUG 2-Stream London SIG
We now have the agenda online for the UKOUG 2-stream London SIG, due to take place on 23rd February. There will be an RDBMS Stream and a RAC, Cloud, Infrastructure and Availability Stream. Mark Rittman will be giving us a keynote talk, with an emphasis on kettles or eating dinner…
-
Continue reading →: Inserting data in SQL*Plus correctly
When inserting data into the database, it is occasionally forgotten (especially by English-speakers) that we need to take steps to ensure we are inserting data correctly and without unexpected character translation. For example, in SQL*Plus we need to ensure we set the NLS_LANG environment variable to the correct setting for…
-
Continue reading →: Oracle Conferences
So the conference season is all over for another year. I have had a bumper crop of conferences and have been a very lucky man to attend and present and learn. OUGN – The Boat – a 2 day conference on a ship. We’re all in it together, and…
-
Continue reading →: Call for Papers – UKOUG 2017 SIGs
All, The time has come for me to plan the upcoming 2017 UKOUG Special Interest Groups. I am chairman of the RAC, Cloud, Infrastructure and Availability (RAC-CIA) SIG and I’m after presentations for the 3 joint SIGs we will be putting on with the RDBMS SIG, plus the stand-alone SIG…
-
Continue reading →: UKOUG Tech 16
It is the UKOUG Tech16 (and App16 & JDE 16) conference in a short few days. As well as giving 2 presentations myself, the first about Disaster Recovery, Far Sync and Fast Start Failover and the second about “RAC for beginners”, I will also be arguing in the DBA v…
-
Continue reading →: OTN Appreciation Day : FlashBack Query
I love OTN, and I love Flashback query. It is a feature looking for an application use-case, but it really can dig you out of a major problem, recovering data you have recently deleted. Here’s a silly example of the power: select * from important_data NAME PHONE_NUMBER ——————– —————————— Partner…
-
Continue reading →: Stats Collection Time Anomaly
Johnathan Lewis (@JLOracle) recently published a short post about Stats Collection Time, talking about the table dba_optstat_operation (and dba_optstat_operation_tasks ), which reminded me about (what I regard as) an anomaly in the output in the NOTES columns in Oracle 12C. I won’t repeat why it’s useful to check these tables…
-
Continue reading →: DOAG Conference + Exhibition
Another quick post to let you know I will be presenting at the German Oracle User Group Conference [DOAG], which runs from 14th-18th of November 2016 This is a huge conference and exhibition over 4 days with many tracks and a vast array of great speakers. I hope to see…
-
Continue reading →: POUG 2-day event
Just a quick post to let you know I will be speaking, with a lot of other Oracle ACE and other excellent speakers at the Pint with/Polish Oracle User Group (Chapter IV), taking place on 7th/8th October in Warsaw. Click on Buy Ticket link to see some of the other…
-
Continue reading →: Accessing STATUS columns efficiently
A frequently reoccuring design problem with relational databases is the issue locating unprocessed rows in a large table, so we know which rows of data are still yet to be processed. The problem with a STATUS column is that it generally has low cardinality; there are probably only a handful…
Neil Chandler's DB Blog 