How to create the Scott Oracle Database Demo Schema?

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

Installing Oracle Sample Schemas (19.3)

Donate to support our blogging work$1.00Click here to purchase. In this post, I'm going to explain how to install Oracle sample schemas, if they are not already installed. If you created a database sing DBCA , you can select to install the sample schemas: Or you can install sample schemas manually after the database creation … Continue reading Installing Oracle Sample Schemas (19.3)

Loading Arabic Data Into Oracle Database using SQLCL

This is a follow up post on my previous post:https://ahmedfattah.com/2019/12/15/loading-data-into-oracle-database-from-text-csv-files/If you read this post, you find that we uploaded some data , part of it was Arabic data, and although it was loaded successfully, the Arabic data was corrupted (appeared as ???????). In this post, we see how we can configure sqlcl to load and … Continue reading Loading Arabic Data Into Oracle Database using SQLCL

Removing Oracle Database Software 12.2 (Grid + Database)

I have an Oracle Restart virtual machine that has both Oracle grid Infrastructure 12cR2 (12.2) and Oracle Database 12c R2 (12.2) + one CDB database called "orcl". I need to fully remove all oracle components from this machine. About the Deinstallation Tool Starting with Oracle Database 12c, the deinstallation tool is integrated with the database … Continue reading Removing Oracle Database Software 12.2 (Grid + Database)

Oracle VirtualBox: Create new Virtual Machine

In this post we are going to create a new virtual machine and configure it to use an already existing virtual disk. This disk contains Oracle Linux 6.3 + Oracle Grid Infrastructure 12.2 + Oracle Database 12.2. We will create the machine two times, one time using the VirtualBox Manager (Gui Interface), and another time … Continue reading Oracle VirtualBox: Create new Virtual Machine

Oracle VirtualBox: Change Disk UUID

This is my first post after my blog was recognized by feedspot as one of the Top 100 Oracle blogs https://blog.feedspot.com/oracle_blogs/ . I'm really happy of this recognition, and I hope I'll continue providing high quality content and sharing a real oracle experience, thanks feedspot. Coming back to our subject today. I have a valuable … Continue reading Oracle VirtualBox: Change Disk UUID

Oracle RMAN Database Full Cold Backup Demo

https://www.youtube.com/watch?v=bJjm1U5x61M For similar script for the full database hot backup: https://ahmedfattah.com/2019/11/14/oracle-rman-full-hot-backup-script/ ThanksAhmed

Oracle RMAN Database Full Hot Backup Demo

https://www.youtube.com/watch?v=EItbFz09Thc For similar script for the database full cold backup, please refer to: https://ahmedfattah.com/2019/11/14/oracle-rman-database-full-cold-backup-demo/ ThanksAhmed

How to Create Autonomous Datawarehouse Database (Always Free Services)?

https://www.youtube.com/watch?v=nOJowoCyw7Y ThanksAhmed