How to install Oracle Database 21c Express Edition on Windows| Download, SQL Developer Configure HR

Hello Friends,

Please check the below information,

Download link for Oracle 21c Express Edition
——————————————————————————–
Option 1::
—————–

Option 2 ::
—————-

Download link for Oracle SQL Developer ::
——————————————————————————–
Option 1::
—————–

Option 2 ::
—————-

—————————————————————————
Unlock/ Install HR Schema SQL Commands ::
—————————————————————————

Firstly, Download HR Schema ZIP File from below link,

Later, extract the ZIP file and Place this folder as shown in video.

First SQL File to be Executed ::
———————————-

@ C:appguru1product21cdbhomeXEdemoschemahuman_resourceshr_main.sql

Parameter 1 ::
———————-
hr

Parameter 2 ::
———————-
users

Parameter 3 ::
———————-
temp

Parameter 4 :: { Only this will change}
———————-
admin

Parameter 5 ::
———————-
$ORACLE_HOME/demo/schema/log

Parameter 6 ::
———————-
localhost:1521/XEPDB1

——————————————————————————
Except Parameter 4, all are CONSTANT Values, there won’t be any changes
——————————————————————————

Second SQL File to be Executed ::
———————————-
@ C:appguru1product21cdbhomeXEdemoschemahuman_resourceshr_cre.sql

Third SQL File to be Executed ::
———————————-

@ C:appguru1product21cdbhomeXEdemoschemahuman_resourceshr_popul.sql

Fourth SQL File to be Executed ::
———————————-
@ C:appguru1product21cdbhomeXEdemoschemahuman_resourceshr_idx.sql

Fifth SQL File to be Executed ::
———————————-
@ C:appguru1product21cdbhomeXEdemoschemahuman_resourceshr_code.sql

Sixth SQL File to be Executed ::
———————————-
@ C:appguru1product21cdbhomeXEdemoschemahuman_resourceshr_comnt.sql

Final SQL File to be Executed ::
———————————-
@ C:appguru1product21cdbhomeXEdemoschemahuman_resourceshr_analz.sql

===================================================

Thanks,

Please Subscribe, Share, Like and Comment on this Video.

[ad_2]

source