HOW TO UNLOCK SH SAMPLE SCHEMA by MANISH SHARMA
Вставка
- Опубліковано 4 жов 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.
Thanks brother for your effort.
My pleasure
Thank you man, God bless you
Always a pleasure. Really happy to be of help.
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! 🚀
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.
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"
Sir please explain in deatail what is SH schema?
You are the man!
Hello, could you explain to me how to install the OE scheme, thank u
very much usefull one
Good one man, thanks a lot :)
Please make a tutorial on UTL_MAIL along with ACL configuration!
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 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?
thank you a lot sir ~ please make a tutorial on data mining~ in sql developer .
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.
Getting the following error: ORA-01031: insufficient privileges. Can you pls help with this
I have followed your steps and done however all the data in hr tables are lost. How can prevent it ?
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
12:50 main installation starts
Helping the community, you are a hero.
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
hello but tables is empty (
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 ua-cam.com/users/shortsLfWkhyNszpU) second switch to the pluggable database which has your schema and then save it open state (refer this ua-cam.com/users/shortsbeYcobrCKG0)