How to Convert LONG to Clob PART 2

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 much faster than Sys_dburigen function but […]

Zero Data Loss DISASTER Database for Standard Edition 2

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 don’t take any responsibility for […]

Indexes with NOSEGMENT a.k.a Virtual Index

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

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 […]

Tables with Memoptimize for Write (fast ingest)

Hi There, this is the second part of this post: http://mustafakalayci.me/2022/02/15/tables-with-memoptimize-for-read/ Oracle adda new feature called memoptimized tables for mostly devices like IoTs. Fast lookup and fast ingest tables. I have already mentioned about fast lookup (memoptimize for read) tables in my previous post and now I want to write about Fast Ingest tables. as […]

Tables with Memoptimize for Read (fast lookup)

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 table hash cluster. instead of […]

How to Restore Dropped PDB

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 point in time recovered duplicated […]

CONTAINER_DATA for Common Users

Hello Everyone (if anyone reading this 🙂 ), it has been a long year and I am glad it is over. As always, we hope the for “a time of period” like new year, birthday etc etc but hope is the only thing that we can hold on. I hope whole world get rid of […]