(Richard Foote) I previously discussed just how easy it is to convert online a non-partitioned table to be partitioned with Oracle Database 12.2.
(Kim Berg Hansen) A new little feature in Oracle Database 12.2 is, that you can convert strings to dates without worrying about exception handling. (That goes also for converting to numbers or timestamps or other datatypes, but here I’ll concentrate on dates.)
(Frits Hoogland) Actually, this is a follow up post from my performance deep dive into tablespace encryption. After having investigated how tablespace encryption works, this blogpost is looking at the other encryption option, column encryption.
(Vyacheslav Rasskazov) There are multiple optimizer features introduced in the Oracle Database 12.2 Release. Bushy Join Trees is the one that I’ll be demonstrating in this post.
(John Hallas) If a Goldengate replicat process fails then occasionally on the restart it skips the correct RBA and ‘loses it’s position’. The relative byte address (RBA) is the location within the trail file to indicate the current transaction.
(Carlos Sierra) Working on the new eDB360 repository I came across this “ORA-00997: illegal use of LONG datatype” while trying to CTAS on the following DBA views:
(Chris Muir) We have released a new YouTube video entitled Using SMS Services with Oracle Mobile Cloud Service as well as a hands-on tutorial. The video and tutorial take you through the steps to configure MCS with 3rd party SMS service provider Syniverse.
(Jeff Smith) I don’t do enough video.
(Jeffrey Kemp) The order in which your deployment scripts create views is important. This is a fact that I was reminded of when I had to fix a minor issue in the deployment of version #2 of my application recently.
(mdinh) Environment: Oracle RAC with DBFS running as oracle