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)
ORA-01031 when using JSON Data Guide
What is JSON Data Guide? A JSON data guide lets you discover information about the structure and content of JSON documents stored in Oracle Database. Some ways that you can use this information include: Generating a JSON Schema document that describes the set of JSON documents. Creating views that you can use to perform SQL … Continue reading ORA-01031 when using JSON Data Guide
sqlcl java errors under different database homes
When trying to run the sqlcl version 22.1 on my new laptop (Windows 11 with many oracle database homes), I got the following errors: I have many oracle homes on my machine (Oracle Database 12cR1, 12cR2, 18c, 19c & 21c). After long research, it looks like that sqlcl pick the JRE under the environment ORACLE_HOME. … Continue reading sqlcl java errors under different database homes
Ahmed AbdelFattah Blog ! 