Oracle Database 18.3 – Page 2 – Ahmed AbdelFattah Blog !

Are you looking for a virtual machine to do some hands-on labs or practice something (i.e. for Educational purposes}? Do you have the time to build these virtual machines yourself? Below are some really nice Virtual Machines, that I invested allot of time to build on Oracle Virtual Box, and that I used them personally … Continue reading Oracle Virtual Machines for Sale !

Oracle Single-Instance Database Creation in a Clustered Environment

Posted on June 13, 2020 by Ahmed Abdel Fattah

https://www.youtube.com/watch?v=LTXFohjMwqY

Is it possible to map one Tablespace to many Tablespaces with impdp?

Posted on March 18, 2020 by Ahmed Abdel Fattah

I got this question from one of my clients. He is going to migrate one database from one platform to another. In this database many users are sharing the same tablespace. For example: In the current database, all application users are sharing the tablespaces “USERS” The client wants to change this, so as each schema … Continue reading Is it possible to map one Tablespace to many Tablespaces with impdp?

The Longest SQL Statement I have ever seen !

Posted on January 19, 2020 by Ahmed Abdel Fattah

Below may be the longest SQL statement that I have ever seen. I don't know if it is written by one developer or group of developers and what is the logic behind it? I really don't like this style of writing sql statements. It is very difficult to be functionally understood. Also, it is very … Continue reading The Longest SQL Statement I have ever seen !

Oracle Read Only Tables

Posted on January 12, 2020January 12, 2020 by Ahmed Abdel Fattah

Starting from Oracle 11gR1, oracle allows us to change a table to be a read-only table. Let us have a quick demo: I'm connecting as user HR ( to a 19c pluggable database). I have a small table "DEPT": So, now I'm going to change the table to be read only table: Now let us … Continue reading Oracle Read Only Tables

How to create the Scott Oracle Database Demo Schema?

Posted on December 25, 2019 by Ahmed Abdel Fattah

https://www.youtube.com/watch?v=yi7N4BXNJfc

How to create the Scott Demo Database Schema?

Posted on December 24, 2019January 9, 2020 by Ahmed Abdel Fattah

Scott schema is the most famous oracle database demo schema that is available since 1990 !. Scott is a database user used for demonstration purposes containing the famous EMP, DEPT, BONUS and SALGRADE tables.This account was named after Bruce Scott (co-author and co-architect of Oracle v1 to v3) and the password was the name of his daughter's cat, Tiger. … Continue reading How to create the Scott Demo Database Schema?