Indexes with NOSEGMENT a.k.a Virtual Index

Published on: 2022-03-302022-03-30 by Mustafa 2 Comments

Hi, Today, an old trainee has contacted with my on linkedin and we talk about some performance issues about a query. During the conversation I suggest to use “virtual indexes” to simulate the index so I wanted to write about virtual indexes and their benefits in this post. if you don’t work on a large […]

3 Ways to Migrate a Non-CDB Database to a PDB

Published on: 2022-03-252022-03-26 by Mustafa Comment

Hi Everyone, Time is fast and everything is changing constantly. Multi-tenant architecture has come many years ago and starting by 21c, it is the only option! So, old “non-cdb” databases must be migrated/converted to a PDB (Pluggable database). I must admin that I was being lazy for many years and I didn’t work much to […]

STOPPED Job While Migrating Non-CDB to PDB via Autoupgrade

Published on: 2022-03-202022-03-20 by Mustafa 4 Comments

Hi, Lately, I started to learn about autoupgrade which is the new upgrade tool for almost anything. Many thanks to Mike Dietrich for amazing blog posts ( https://mikedietrichde.com ). His blog is a real treasure. I am about to migrate some non-cdbs to pdbs and before doing that I wanted to learn my options about […]

How to install Oracle Database Options like Spatial, Label Security etc After DB Creation

Published on: 2022-03-032022-03-11 by Mustafa 4 Comments

Hi, yes, I am aware that title is a little bit long and too informative but I believe it is necessary because terms are complicated according to me. When you say “option” it could be many thinks like “advanced compression” option in EE or Spatial option or Partitioning option and not all of these are […]