Oracle Database 18c – Ahmed AbdelFattah Blog !

Auditing Individual Functions/Procedures inside a PL/SQL Package

Posted on September 29, 2022 by Ahmed Abdel Fattah

I got this question from one of my clients:How can I Audit Individual Functions/Procedures inside a PL/SQL Package?. Let us build a quick demo: This is just a sample package Let us try to enable this type of auditing using the following command:audit execute on scott.emp_pack.CreateEmp by access;I got the following error: As per Oracle … Continue reading Auditing Individual Functions/Procedures inside a PL/SQL Package

Polymorphic Table Functions in Oracle Database 18c

Posted on December 1, 2021 by Ahmed Abdel Fattah

https://www.youtube.com/watch?v=VPX5MwHeC-4

Oracle Database 18c New Features in one Image

Posted on November 26, 2021November 26, 2021 by Ahmed Abdel Fattah

The following map contains a high-level summary of the key Oracle Database 18c new features.Compared to Oracle Database 12.2, 18c has 134 new features in different focus areas. [Please zoom in to see the below image clearly] For detailed information about all new features, please refer to the :Oracle Database 18c New Features Guide We … Continue reading Oracle Database 18c New Features in one Image

Oracle Backup & Recovery Hands-on Practice – Oracle Database 18c VM

Posted on September 30, 2020October 2, 2020 by Ahmed Abdel Fattah

Do you want to practice recovering from the following common failures (with a guided step-by-step procedure)?: Recovering from a critical file loss (SYSTEM , UNDO)Recovering from a non-critical file lossRecovering from the loss of the control fileRecovering from the loss of all control filesRecovering from the loss of an inactive redo log fileRecovering from the … Continue reading Oracle Backup & Recovery Hands-on Practice – Oracle Database 18c VM

How to Modify an Oracle Database Windows Service?

Posted on August 4, 2020October 7, 2021 by Ahmed Abdel Fattah

This is a quick post about how we can change some parameters for one database winodws service. Background:I have a database called PROD with version 19.3, running on Windows. Its service looks like: This Windows service was configured with the parameter file:D:\app\db193\WINDOWS.X64_193000_db_home\database\initPROD.oraFor some reason, I want to change the parameter file to be:M:\app\oracle\database\initPROD.ora{Actually, I'm preparing … Continue reading How to Modify an Oracle Database Windows Service?

Oracle Virtual Machines for Sale !

Posted on June 13, 2020February 2, 2021 by Ahmed Abdel Fattah

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 !

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?

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