How to Convert LONG to Clob PART 2 Mustafa, 2022-05-062022-05-06 Hi, I just want to write a small post today. Some time ago, I shared a way to convert long to clob in a query directly:Ā https://mustafakalayci.me/2020/04/06/how-to-convert-a-long-column-to-clob-in-a-query/ Even if this method works, it works really slow and anything slow annoys me! So, I want to share another method which is much… Continue Reading
Zero Data Loss DISASTER Database for Standard Edition 2 Mustafa, 2022-04-22 Hi, As you know Data Guard is an Enterprise Edition option and only accepted method to protect your data against a “DISASTER” (DR) is data guard. How about Standard Edition 2(SE2)? Is this possible? Well I did it so, king of yes š with some risk of course. Warining: I… Continue Reading
3 Ways to Migrate a Non-CDB Database to a PDB Mustafa, 2022-03-252022-03-26 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… Continue Reading
STOPPED Job While Migrating Non-CDB to PDB via Autoupgrade Mustafa, 2022-03-202022-03-20 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… Continue Reading
How to install Oracle Database Options like Spatial, Label Security etc After DB Creation Mustafa, 2022-03-032022-03-11 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… Continue Reading
Tables with Memoptimize for Read (fast lookup) Mustafa, 2022-02-152022-02-15 Hi, I would like to share my initial thoughts about memoptimized for read (fast lookup) tables in this post. fast lookup tables came with 18c and they are here to provide faster access to a table if you are using primary key with a equality condition. this is basically single… Continue Reading
How to Restore Dropped PDB Mustafa, 2022-02-04 Hi, it seems easy, right? Well, not that much but not that hard either. if you drop a pdb in a cdb, you cannot restore it using current database because when you drop the pdb, all information about the pdb is lost. So, what is the solution? you need a… Continue Reading
Hierarchical Blocking Session List Mustafa, 2021-10-19 Hi, Today, I needed to list all blocking sessions hierarchically. As you know, all information about sessions (and blocking sessions) are in gv$session (or just v$session if you are using single instance) view. I wanted to see who is blocking who and blocker at the top. you can write simple… Continue Reading
Enable Unified Audit on Linux and Windows Mustafa, 2021-09-08 Hi, As you know, since 12c Oracle introduce Unified Auditing which has much more capabilities than standard auditing. Creating policies, audit conditions, top level auditing etc. By default Oracle uses “mixed” mode which allows you to run unified auditing commands and standard auditing. you can check if you are using… Continue Reading