HOW TO UNLOCK SH SAMPLE SCHEMA by MANISH SHARMA
HTML-код
- Опубликовано: 8 сен 2024
- A detailed tutorial explaining how to download, unlock and then configure Sales History (SH) schema in Oracle Database. SH User comes with free large data sets organised for data analysis. For more details check out this blog www.rebellionri...
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: Coming Soon
Previous Tutorial
►►Download Link github.com/ora...
► How to install oracle 19c: • How To Install Oracle ...
►DBA_TABLESPACES (Facebook Video) / 631254480942672
►How To Find DB_Home: • How to find out the SI...
-------------------------------------------------------------------------
►►►Social Media - Where I sort of Live
/ therebellionrider
/ rebellionrider
/ rebellionrider
/ mannbhardwaj
-------------------------------------------------------------------------
►►►Books I refer to
PL/SQL amzn.to/2QE1jX0
Performance Tuning amzn.to/2sgiAw4
1z0-071 Exam amzn.to/2sgfeJw
Python Programming amzn.to/305UEbh
-------------------------------------------------------------------------
►►►Camera Gears
Favourite Lens 1 amzn.to/2NbUE46
Favourite Lens 2 amzn.to/37SMA03
My New Video Light amzn.to/35FgXFK
Camera Remote [Secrete Weapon] amzn.to/2QH8aPj
Super-Fast inexpensive SD Card amzn.to/2shqhCg
Awesome Vide Mic amzn.to/2QGdliz
On-Camera Mic Worth Every Penny amzn.to/2tIEkBd
Sound Recorder amzn.to/2QZmeTm
Camera- I am using Canon 600d which is not available in the Market Now. But I am soon switching over this camera amzn.to/2R2W3v8
All of the above are affiliate links. Please use them to support the channel
#RebellionRider #OracleDatabase #OracleUser
For More Details make sure to read the blog. Here is the link www.rebellionrider.com/how-to-unlock-sh-schema-in-oracle-database/
How connect Sh...i forgot my pass please tell me
SH use?
if you use the same command line to execute the command, your PWD is sh_pass. You can connect to sys or system and change pwd if you do not remember. you need to use Alter user sh identified by to change PWD.
Tq so much brother...I struggled to install this for four days. But after watching your video I am now fully done. Thank you very much.🙏
Always a pleasure. Happy to be of help.
Thanks for posting, successfully created user "SH". thank you very much. expecting more videos like this. please share more DBA related.
Muchas Gracias, Saludos desde Panamá.
I am glad you find my video helpful. Your support and appreciation means a lot to me.
thank u brother i successfully create user SH without errors
Great job, buddy! 👍 Happy to hear that you created the user SH smoothly! If you encounter any more challenges or have questions, feel free to ask! 🚀
Thank you man, God bless you
Always a pleasure. Really happy to be of help.
Thanks brother for your effort.
My pleasure
hello manish my name is habimana felix from RWANDA..Your videos help a lot .
Hi Manish, your HR and SH schema videos are great. could you do other sample database schema unlock as well like OE and PM on 19C DB.
Sir please explain in deatail what is SH schema?
Do you have videos for Bus Intell, Info Exchange, Order Entry, product Media or Shipping?
Great Thank you so much , I was struggling all the day to find a solution, But now when I tried to make same steps with HR and OE it gives me error " Unauthorized"
very much usefull one
Hello, could you explain to me how to install the OE scheme, thank u
thank you a lot sir ~ please make a tutorial on data mining~ in sql developer .
Please make a tutorial on UTL_MAIL along with ACL configuration!
You are the man!
Good one man, thanks a lot :)
When you open the script, where are you opening the script in?
Did you open in SQL Developer, in SQL, in SQLPlus? There are detail you are leaving out and they may be minor details, but it prevents us from following you.
Hi Manish, hope you're well. I tried the same with my already existing 11g xe database in my laptop.
I could see the SH user is created, however no objects are created.
I rechecked using select * from dba_users where owner='SH'; ---0 results fetched.
Is there any issues?
Happy to hear from you soon. Have a great day!
Okay, I got SQLPlus to show SH as User. When I go to SQL Developer, I see the HR database from that video, but I do not see the SH database.
Hi Manish Sharma, I successfully created User SH. When I expand the Tables section, no tables have been found. I don't understand what went wrong? Could you help?
Hi i am working as a plsql developer. But i have questions for you could you tell me why we use array in plsql if we have cursor in plsql . I think both are work same . Could explain me .
Hello
While installing Oracle 18c I am getting an error in the last step:
which shows Oracle services for Microsoft transactions server failed .
PLZ help me out in solving this
Getting the following error: ORA-01031: insufficient privileges. Can you pls help with this
12:50 main installation starts
Helping the community, you are a hero.
I have followed your steps and done however all the data in hr tables are lost. How can prevent it ?
I have configured the Sales History schema, how do I access the tables etc. on Oracle SQL developer?
user is sh
password is the second parameter in this video that you specified
bro i have installed and i opened and i have logged successfully to sh schema and later i tried to login it is showing username and password denied but i never changed the details from sh and sh_pass now what i have to do?
first check if the pluggable database which is holding your SH schema is open or not (refer this ruclips.net/user/shortsLfWkhyNszpU) second switch to the pluggable database which has your schema and then save it open state (refer this ruclips.net/user/shortsbeYcobrCKG0)
hello but tables is empty (