How to Unlock Scott User in Oracle Database 21c Express Edition | Unlock Scott Schema in Oracle 21c
ฝัง
- เผยแพร่เมื่อ 5 ก.ย. 2024
- Hello Friends,
Please follow/ Execute the below steps as shown in the Video
=============================================================
**************** Website to be launched Soon *************************
=============================================================
Watch complete Setup Video for Oracle Database 21c Express Edition Software on Windows Operating System
=============================================================
Video Link : • How to install Oracle ...
Download link for Oracle 21c Express Edition
--------------------------------------------------------------------------------
Option 1::
-----------------
www.oracle.com...
Option 2 ::
----------------
drive.google.c...
Download link for Oracle SQL Developer ::
--------------------------------------------------------------------------------
Option 1::
-----------------
www.oracle.com...
Option 2 ::
----------------
drive.google.c...
---------------------------------------------------------------------------
Unlock Scott User/Schema SQL Commands ::
---------------------------------------------------------------------------
Execute the below SQL Statement ::
==================================
@ C:\app\guru1\product\21c\dbhomeXE
dbms\admin\scott.sql
Later, Unlock the Scott User by executing below SQL Statement ::
=====================================================
alter user scott identified by tiger account unlock;
===================================================
Thanks,
Please Subscribe, Share, Like and Comment on this Video.
Excellent video you saved our time Thanks Dear
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
God Bless you, man! Tks
Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊
REALLY YOU ARE GREATE BRO ...TQ U SO MUCH ...
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
Thank you so much !
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
Sir, please make a video on how to unlock SCOTT user in mac os also. We are not able to unlock SCOTT user in macos.
I will try to give my best
@@techstudio8268 Thank You So Much Sir, I'm eagerly waiting for your video for MacOs. My humble request to you Please upload it soon.
I am not able to view tables available in Scott schema in SQL PLUS
First you need to connect to Scott schema with connection string, i prefer you to use SQL developer gui software, it will be very friendly
Didnt know the service name..How to find it..Helpme brother..
By default it will be XEPDB1
hi why my SQL developer UI looks so blurred
can you help ??
Ohh.... it's really weird. Well, if it is a software issue, I can guide you, but looks like it's your pc issue.