How to Unlock HR Schema in Oracle 21c SQL Developer?

Показать описание

Hi Guys, Welcome to SASS Tech Youtube Channel.

This video is for dumping the HR schema in Oracle SQL Developer

Please follow/ Execute the below steps as shown in the Video

=============================================================
Watch complete Setup Video for Oracle Database 21c Express Edition Software on Windows Operating System
=====================================================================================================

Download link for Oracle 21c Express Edition
--------------------------------------------------------------------------------

Download link for Oracle SQL Developer ::
--------------------------------------------------------------------------------

---------------------------------------------------------------------------
Unlock/ Install HR Schema SQL Commands ::
---------------------------------------------------------------------------
Firstly, Download HR Schema ZIP File from below link,

click on sourcecode ZIP file

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

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

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

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

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

Parameter 4 :: Only this will change
---------------------------------------------------------
admin --- Provide your system admin password.
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 ::
----------------------------------

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

Fourth SQL File to be Executed ::
----------------------------------

Fifth SQL File to be Executed ::
----------------------------------

Sixth SQL File to be Executed ::
----------------------------------

Final SQL File to be Executed ::
----------------------------------

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

Thanks,

Stay connected with us ...

🔔Subscribe our tech channel...

SASS TECH Creations

👍 Like...🔄Share... ✉️Comment...