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?
How to create the Scott Demo Database Schema?
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?
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
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 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 Application Server 10g – Increase JVM Heap Memory Size
Background: One of my customers still has the old oracle application server (10.1.2.3.0), that is used to host a forms and reports application. Application Tier is running on Windows server (Windows 2008 R2 64-bit) Customer has 6-sites, each one has its own application server (no load balancer). All branches are connecting to the same database … Continue reading Oracle Application Server 10g – Increase JVM Heap Memory Size
How to Create Autonomous Datawarehouse Database (Always Free Services)?
https://www.youtube.com/watch?v=nOJowoCyw7Y ThanksAhmed
How to Create Autonomous Transaction Processing Database (Always Free Services)?
https://www.youtube.com/watch?v=eF9LwCHCrRo ThanksAhmed
Ahmed AbdelFattah Blog ! 