I’d love to take this opportunity to wish you a wonderful festive season – and all the very best for 2023. If you’ve got a few moments amongst the mince pie eating, here are some great blogs and videos to read and watch: Blogs of the month Star Schema Design…
Category: Oracle
Analytics
Read more
November News
Blogs 1. ORA-00479: RVWR process terminated with error followed by ORA-479 Mahmmoud Adel posted about an error that occurs on a 19c DB, when trying to enable the FLASHBACK mode on a standby DB. He gives an analysis and solution. 2. Natural Selection & Converged Databases (Oracle finds good solutions…
Conference
Read more
Back to School
Have you had a good Summer? Here’s a round up of the blogs that have caught my eye over July and August: Why you simply can’t upgrade from Oracle 11g or 12c to Oracle 23c Mike Dietrich shares why this isn’t just a simple upgrade. You MUST upgrade to Oracle…
Analytics
Read more
News from May 2022
Blogs of the Month qgis with Oracle Cloud Database “One of these complex situations is the connection to an Always Free Autonomous Database. Oracle tries to secure the database access, so by default it does not allow a simple connection with host, port, service_name and username/password. Instead a wallet is provided…
Oracle
Read more
April’s Blogs
Blogs of the Month Building a REST API with ORDS, PL/SQL Functions, & Arrays Jeff Smith shares how to build a REST API that return a JSON array list of strings. 2. Configuring Nginx on AWS EC2 for Oracle GoldenGate 21c This blog begins with: “When installed, Oracle GoldenGate (Microservices) will…
Cloud
Read more
Autumn Days…
Blogs of the month 1.10 Best Database Management Software of 2021 (+ Examples) This blog lists the Best Database Management Software as: ManageEngine Applications Manager DBeaver Raima Database Manager Valentina Redis Enterprise DbVisualizer Oracle Database Database Labs Sadas Engine Percona Monitoring and Management and gives an extensive overview of each….
Analytics
Read more
Latest blogs and videos
Just a few for these chilly October/November evenings … Blogs of the Week 1. Announcing Oracle APEX 20.2 Joel Kallman shares (the original post is here) : “This release of APEX introduces several new features and enhancements to help developers be more productive than ever before. From the all new Cards…
APex
Read more
An early July blog…
Blogs of the Week 1. Announcing SQL Developer, SQL Developer Data Modeler, & SQLcl versions 20.2 Jeff Smith says, “However, there are bug fixes that we need to get into your hands, and our developers have never stopped working on new features, so we ARE releasing version 20.2, TODAY.” He…
State of the OBIEE Market
Recession, what recession? Ever since I started up Majendi (Now Rittman Mead), the market for Siebel Analytics (now Oracle BI) has been a roller coaster. Looking back, supply and demand for consultants / contractors / permies has either been heavily biased to supply or to demand. Getting the balance right…
Interesting Note from Oracle
This note was published today. It may explain the questions I have been getting. “The Standard Cost General table (W_STANDARD_COST_G) and the Exchange Rate General table (W_EXCH_RATE_G) are general reference tables. Both tables have surrogate keys (ROW_WID). But unlike dimension surrogate keys, these surrogate keys are not referenced as foreign…