Installing Oracle Sample Schemas (19.3)
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: Please note that using this method (dbca) will install only the HR sample schema. Or you can install sample schemas … 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 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
The beauty of Visualization with Oracle Database
https://youtu.be/3N2wgayry4g ThanksAhmed
What is the difference between Oracle RAC One Node and Oracle RAC?
https://www.youtube.com/watch?v=ZM6ckWFlyeM ThanksAhmed
What is the difference between object_id and data_object_id?
If you describe the dba_objects, you will find two IDs called: object_id & data_object_id, so , what is the difference between them? object_id is the primary key. Any object will have object_id irrespective, if it has an associated segment or not. For example, sequence, package, synonym are all objects with object_id but without any physical … Continue reading What is the difference between object_id and data_object_id?
Protected: Oracle RAC 12c Installation on Linux
There is no excerpt because this is a protected post.
Ahmed AbdelFattah Blog ! 