Oracle 21c installation on windows | How to import HR schema in oracle 21c |Oracle 21c installation

Video Description

#JUSTIN#ORACLE#SQL#TAMIL#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers Chapters: 0:00 Oracle 21C installation on windows 11 1:12 Oracle 21C installation steps 2:17 Oracle database 21C installation on windows 10 4:35 SQL Developer configuration 10:54 How to import HR schema in oracle 21c how to install oracle xe 21c on windows 10, how to install oracle database 21c on windows 10, install oracle database 21c on windows 10, install oracle database 21c on windows, how to install oracle 21c, oracle database 21c installation on windows 10, oracle installation on windows, oracle 21c installation on windows 11, ======================================================== 🌕Please join in the below Oracle PLSQL group for technical discussion https://chat.whatsapp.com/FCXjqk6EHhMKlOPzlQxb0e 📌 visit website for tutorial and interview questions https://www.nicitacademy.com/ ======================================================== Step 1: Download all the software from given link below ======================================================== 1. Oracle 21C xe(Express edition) Option 1: https://drive.google.com/file/d/1fxO5mnWWM_wUWOeXwAeCDwcyQRtZKF_E/view?usp=sharing 2. Download SQL developer application Option 1: https://drive.google.com/file/d/1vxx7JVH7Pci8JcyPp48b1ly_S20E2tYF/view?usp=sharing Option 2: https://www.oracle.com/tools/downloads/sqldev-downloads.html 3. Download HR schema dump Option 1: https://drive.google.com/file/d/1om_vUDXjgIyRPUv8mIBYxJB_3U_p3Sm2/view?usp=sharing Step 2: Unzip all the software by using winrar or winzip Step 3: Install Oracle 21C XE Step 4: Connect ADMIN schema with SQL developer Place the un Zipped HR schema dump file in the below path: ================================================= C:\app\LENOVO\product\21c\dbhomeXE\demo\schema Execute the below steps in ADMIN schema (In SQL Developer) @ C:\app\LENOVO\product\21c\dbhomeXE\demo\schema\human_resources\hr_main.sql Parameter 1 : ------------ hr Parameter 2 : ------------- users Parameter 3 : ------------- temp Parameter 4 : ---------------------- admin Parameter 5 :: ---------------------- $ORACLE_HOME/demo/schema/log Parameter 6 :: ---------------------- localhost:1521/XEPDB1 Create the connection for HR schema Execute the below steps in HR schema (make sure to change the corresponding file path as per your system name) ======================================================================= select * from employees; -- No data will be present initially. Then execute the below commands in HR @ C:\app\LENOVO\product\21c\dbhomeXE\demo\schema\human_resources\hr_cre.sql @ C:\app\LENOVO\product\21c\dbhomeXE\demo\schema\human_resources\hr_popul.sql @ C:\app\LENOVO\product\21c\dbhomeXE\demo\schema\human_resources\hr_idx.sql @ C:\app\LENOVO\product\21c\dbhomeXE\demo\schema\human_resources\hr_code.sql @ C:\app\LENOVO\product\21c\dbhomeXE\demo\schema\human_resources\hr_comnt.sql @ C:\app\LENOVO\product\21c\dbhomeXE\demo\schema\human_resources\hr_analz.sql Thanks, Please subscribe the channel and click on bell icon for more updates on Oracle and SQL ============================================================ 📌 Oracle SQL - Complete tutorial Playlist https://youtube.com/playlist?list=PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF ***************************************************************************************************** 📌 Oracle SQL Day wise Video: Oracle SQL Tutorial - Day 1 - https://youtu.be/hLnKjYGr730 Oracle SQL Tutorial - Day 2 - https://youtu.be/XpgjXvnfZec Oracle SQL Tutorial - Day 3 - https://youtu.be/TmYqeFfHyyc Oracle SQL Tutorial - Day 4 - https://youtu.be/tYQfBgUCpoI Oracle SQL Tutorial - Day 5 - https://youtu.be/4qJJxQuHLC4 Oracle SQL Tutorial - Day 6 - https://youtu.be/CkaqluC2afE Oracle SQL Tutorial - Day 7 - https://youtu.be/BSiCWzj-py8 Oracle SQL Tutorial - Day 8 - https://youtu.be/KtUCyG2cZe4 Oracle SQL Tutorial - Day 9 - https://youtu.be/B0JbGbWsEIA Oracle SQL Tutorial - Day 10 - https://youtu.be/gRC3ndWLsoo **************************************************************** 📌 Oracle SQL Full Course in 6 hours - TAMIL https://youtu.be/d04g-tnAxSQ =============================== 📌Oracle SQL Day wise Video: TAMIL =============================== Oracle SQL in Tamil - Day 1 - https://youtu.be/ggy55LkNZy0 Oracle SQL in Tamil - Day 2 - https://youtu.be/n11G87EOpUg Oracle SQL in Tamil - Day 3 - https://youtu.be/i7jSpxrXAh8 Oracle SQL in Tamil - Day 4 - https://youtu.be/5nQf0h_t53s Oracle SQL in Tamil - Day 5 - https://youtu.be/sZmv_PeHmbM Oracle SQL in Tamil - Day 6 - https://youtu.be/rsDzGkUxztI Oracle SQL in Tamil - Day 7 - https://youtu.be/OK1TM5bc1l0 Oracle SQL in Tamil - Day 8 - https://youtu.be/SS7gUqmurRg Oracle SQL in Tamil Day 9 - https://youtu.be/gORDQicSvf0 Oracle SQL in Tamil Day 10 - https://youtu.be/BXUpBiLvip8 Audio track credit: Believe Music