How to Install Scott Schema in Oracle 19C

[@sjshirolkar]

Very nicely explained . THanks for making it so easy to all of us.

[@DataScienceCenter]

My pleasure 😊

[@itsajoetime]

Thank you so much for your information and help, finally figured it out only because of you.

[@DataScienceCenter]

Great to hear!

[@sjshirolkar]

Thankyou Sir for the detailed explanation

[@DataScienceCenter]

Keep watching

[@mangeshbadgujar1400]

very well explained... Thanks man

[@DataScienceCenter]

Glad you liked it!

[@VermontCA1864]

Thank you very much!

[@DataScienceCenter]

You're welcome!

[@ericksalazar7025]

Thanks!!! So useful 😀

[@DataScienceCenter]

Glad it was helpful!

[@AravindasaiGandham]

In scoot .sql user is not connected?

[@Jeetu.92]

My SQL tool is not Show READ ONLY NO show from MOUNTED

[@Lakimohanty]

Same problem bro

[@D.K.S.191]

SQL> ALTER USER SCOTT IDENTIFIED BY TIGER ACCOUNT UNLOCK;
User altered.
SQL> SHOW USER;
USER is "SYS"
connected with SYS instead of SCOTT USER.
how to connect with scott ?

[@DataScienceCenter]

conn SCOTT/TIGER@YOURDATABASE_NAME

[@babupemmada1580]

HI Bro, pls help me how to ifx this scott user to connect?

[@manjunathamr1872]

Hi sir. i am facing issue with installing scott schema as i followed steps given in this video ....copy pasted scott.sql link but showing not connected .....please help sir

[@karasevda1451]

Same here. I began to hate this oracl😂

[@DataScienceCenter]

its seems that you are not using proper password for scott user,
Follow the following steps:
i. connect with sys user,
ii. write the command :
alter session set container = orclpdb
iii. reset the user password:
alter user scott identified by tiger;
iv. connect with scott user:
conn scott/tiger@orclpdb

[@bote6129]

Thank you sir, but I face a problem that after I run the scott.sql, when I try to show the users, it shows SP2-0640 error, I lost the connection, is there any solution?

[@DataScienceCenter]

its seem that you got disconnected, connect again with scott user.

[@tasmiar6440]

@@DataScienceCenter I'm having the same problem.
After running the command:
F:\app\DB_HOME
dbms\admin\scott.sql
I wrote: select username from all_users;
then this error occured:
SP2-0640: Not connected
What should I do?

[@irinabotici6812]

@@tasmiar6440 disconnect (for me CTRL + C) then connect again (for me sys as sysdba, then the password), after that wrote again "select username from all_users;"

[@azizfatima6645]

when i write show pdbs; ......its not showing anything
what to do..help me out sir?

[@DataScienceCenter]

its seems that your database is shutdown. first write the following command
startup open;
and then write show pdbs;

[@bhargavkapuganti3644]

Bro it is sceen not connected bro so please explain us

[@DataScienceCenter]

connect with sys as sysdba and then write the commanad STARTUP OPEN

[@swarupbiswal4499]

Sys as sysdba
Password??

[@DataScienceCenter]

you can press enter. password is not necessary for sys user.

[@shubhambisen7656]

SQL> conn scott/tiger
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.

[@DataScienceCenter]

alter the user and then try to connect with scott user, make sure you are using proper database name.

[@raghunadhreddy4784]

hi,
i am getting like this while enable the scott user. Kindly help how to proceed
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MOUNTED

[@DataScienceCenter]

its mean your database is shutdown. first startup open your database. follow the following video for this:
th-cam.com/video/2pVd8nj-csI/w-d-xo.html