Multitenant Pills: Partial PDB cloning (and cleanup)
This post was originally published on this siteWhen consolidating to multitenant, there are several consolidation patterns. Big, complex databases usually have special requirements for which it might be a good choice to go to single-tenant (a single PDB in one CDB) Small, relatively easy databases…
Last Week in Stream Data Integration & Stream Analytics – 15.5.2020
This post was originally published on this siteThis is the 191st edition of my blog series blog series around Stream Data Integration and Stream Analytics! Took me a bit later to compile this weeks edition….. in fact it is almost 3 weeks together! As every…
Multitenant Pills – Change DBID for an existing PDB
This post was originally published on this siteWhen you plug the same PDB many times you have to specify “AS COPY” in the syntax: CREATE PLUGGABLE DATABASE ludo AS CLONE USING ‚/u01/app/oradata/ludo/ludo.xml‘; Otherwise, you will get an error similar to: ERROR at line 1: ORA-65122:…
I was a guest in David Tielkes DevDaily 30 and spoke about Azure
This post was originally published on this siteSo today I was a guest at my friend David Tielkes DevDaily webcast to speak about the Microsoft Azure Cloud. But beware, it is in GERMAN. Check out his channel here: https://www.youtube.com/channel/UCQnJlfHdJ2OolZSa4h2H5Rg
Azure Tip 6: Azure Facts: Azure Reservations
This post was originally published on this siteSo I decided to start a new section in my Azure Tips that is called Azure Facts. The idea is to write very short blog posts about a certain topics and list all the facts. I use this…
Parallel Oracle Catalog/Catproc creation with catpcat.sql
This post was originally published on this siteWith Oracle 19c, Oracle has released a new script, annotated for parallel execution, to create the CATALOG and CATPROC in parallel at instance creation. I have a customer who is in the process of migrating massively to Multitenant…
And the winner is…
This post was originally published on this site10 days ago I started a raffle, where you could complete a SQL Workout and win a copy of Practical Oracle SQL. The deadline was end of April UTC, so today I found the winner… 9 raffle participants…
Last Week in Stream Data Integration & Stream Analytics – 28.4.2020
This post was originally published on this siteThis is the 190th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As every week I was also updating the following two lists with the presentations/videos of the current week: Presentations from…
Oracle Cloud Infrastructure and SSH Keys – Jump!
This post was originally published on this siteJump! In our Trivadis Oracle Cloud Infrastructure training environments, we never use direct access to an application or database server by a public IP address. For this case, we use an Oracle Linux based bastion host which acts…
Social Media @trivadis