i have successfully unlocked thanks man i dont know ur name but ur explanation is very good bro.I have recently attented for sql dev course how ever my application got crashed and have reinstalled but no default tables have in it by ur process helped thanks again man it helps for my etl testing
Hai, I will note two points one to those who are struggling to install oracle sqldeveloper on their pc. and two unlock hr schema 1)If any one find problems during installation by checking ur disks,u guys can restart ur pc to factory reset and try instllation it will work, these problems i encounterd and followed the procedure and got sucessfully installed oracle sql developer on my pc. 2)this tutorial to unlock hr schema is very usefull it will defenitly work if u are using 18c.
Hello, I am getting error alter user hr identified by hr; alter user hr identified by hr * ERROR at line 1: ORA-01918: user 'HR' does not exist Please assist.
At 4:59 when I run " select * from tab; "command, The result is " no rows selected. what is the problem, and how to fix it. Note: I'm trying to unlock HR Schema in Oracle Database 21c XE Express Edition.
I have a problem.When I run this sql statement :"select name,open_mode from v$pdbs;" I only get a single row.Wasn't I supposed to have that second line as well?
@@techstudio8268 Hi, I successfully unlock and connect to the local Oracle HR scheme. However, when I restart the computer again, the connection is gone. It says the database is not open. ORA-01109: database not open ORA-01109: database not open