(Franck Pachot) The current message about Oracle Database is: multi-model database. That’s not new. At the time of Oracle 9i, Object Oriented was the trend, with all the flexibility of polymorphism, but without the mess of unstructured data and without the inconsistency of NoSQL.
Tag: Oracle
Vagrant tips’n’tricks: changing /etc/hosts automatically for Oracle Universal Installer
(Martin Bach) Oracle Universal Installer, or OUI for short, doesn’t at all like it if the hostname resolves to an IP address in the 127.0.0.0/0 range. At best it complains, at worst it starts installing and configuring software only to abort and bury the real cause deep in the logs.
Introducing Oracle Cloud API Gateway – the light weight public or private router to public and private OCI endpoints
(Lucas Jellema) Two days ago, the API Gateway service on Oracle Cloud Infrastructure went live – read the announcement. This is a crucial component for many applications and in many solution designs. This new API Gateway is a prime candidate for example for inclusion in our reference architecture fo
R (ROracle) and Oracle DATE formats
(Brendan Tierney) When you comes to working with R to access and process your data there are a number of little features and behaviors you need to look out for.
Oracle Database 19c Automatic Indexing – Indexed Column Reorder (What Shall We Do Now?)
(Richard Foote) I previously discussed how the default column order of an Automatic Index (in the absence of other factors) is based on the Column ID, the order in which the columns are defined in the table.
Manual upgrade to Oracle 19c (CDB/PDB)
(Stefan) Actually it is very cool to do everything with so called „auto tools“. If you prefer to do the Upgrade to 19c manually and step-by-step then you can follow my article and have fun otherwise skip this blog article
Datapump Import Fails on Tables With Extended Statistics
(Bobby Durrett) Quick post before I leave on vacation. We used Datapump to import a schema from an 11.2 HP-UX database to a 19c Linux database and got errors on a few tables like these:
REST Enable Schema Aliases and SQL Developer Web
(Jeff Smith) If you have ORDS 19.4 up and going, with SQL Developer Web enabled, you’re almost ready to login and start running queries.
Useful scripts for working with Oracle directories on AWS RDS
(Matthias Hoys) Working with directory objects on the Oracle RDS platform on Amazon Web Services (AWS) is a bit different compared to a native installation of the Oracle database.
Refactoring using Functional Programming
(Arvind Kumar GS) Refactoring is used for making code more readable and understandable to humans, thereby maintainable. It does not effect the functionality. In fact it should not effect the functionality.