In this post, I’m going to explain how to install Oracle database sample schemas on Oracle database version 21c. Download the Scripts: Starting from Oracle database 12.2 ,the sample schemas setup scripts are now available from GitHub. Pick the release that matches your database release: https://github.com/oracle/db-sample-schemas/releases Extract the files: Extract the file “db-sample-schemas-21.1.zip” directly into $ORACLE_HOME/demo/schema, … Continue reading Installing Oracle Database Sample Schemas (21c)
For Loop in Oracle Database 21c and before 21c
This is a quick comparison between the "For Loop" in oracle database 21c and pre Oracle 21c.In Oracle Database 19c: set serveroutput ondeclare i number(5,1);begin for i in 1 .. 5 loop dbms_output.put_line (i); end loop;End;/ In Oracle Database 21c: set serveroutput onbeginfor i number(5,1) in 1 .. 6 by 2, reverse 7 .. 14 … Continue reading For Loop in Oracle Database 21c and before 21c
Oracle Database 21c Creation via DBCA hangs at 36%
Background I installed Oracle Database 21c on Windows 10 successfully. See the following video for the detailed installation steps: https://www.youtube.com/watch?v=QFovPSi8FKw After that I tried to create a sample database using the dbca (Database Configuration Assistant), but it hangs at 36%, as indicated in the following screen shot: If we examined the dbca log file: We … Continue reading Oracle Database 21c Creation via DBCA hangs at 36%
Creating Oracle Database 21c on Windows
Oracle Database 21c Installation on Windows
Oracle Database 21c Documentation
Oracle Database is the world's most popular database. Available on cloud and on-premise platforms, Oracle Database 19c is the most recent long term release, with an extended support window. Oracle Database 21c is the latest innovation release, initially available on Oracle cloud through Autonomous Database Free Tier and Database Cloud Service. For Oracle Database 21c documentation:https://docs.oracle.com/en/database/oracle/oracle-database/21/index.html For Oracle Database … Continue reading Oracle Database 21c Documentation
Ahmed AbdelFattah Blog ! 