No video :(

How to Install Scott Schema in Oracle 19C

Подписаться 2,7 тыс.

Просмотров 13 тыс.

50% 1

How to install scott schema in Oracle 19C/18C/12C
i. connect with the sys as sysdba
ii. alter session set container = oprclpdb;
iii. select username from all_users;
iv. F:\app\DB_HOME
dbms\admin\scott.sql
Edit scott.sql
add the service name or pluggable database name in file
connect scott/tiger@orclpdb

Опубликовано:

25 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 35

@sjshirolkar 3 года назад

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

@DataScienceCenter 3 года назад

My pleasure 😊

@itsajoetime 3 года назад

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

@DataScienceCenter 3 года назад

Great to hear!

@sjshirolkar 3 года назад

Thankyou Sir for the detailed explanation

@DataScienceCenter 3 года назад

Keep watching

@ericksalazar7025 2 года назад

Thanks!!! So useful 😀

@DataScienceCenter 2 года назад

Glad it was helpful!

@mangeshbadgujar1400 2 года назад

very well explained... Thanks man

@DataScienceCenter 2 года назад

Glad you liked it!

@user-wf7fj9bk9e 28 дней назад

In scoot .sql user is not connected?

@VermontCA1864 2 года назад

Thank you very much!

@DataScienceCenter 2 года назад

You're welcome!

@babupemmada1580 9 месяцев назад

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

@Jeetu.92 2 года назад

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

@Lakimohanty Год назад

Same problem bro

@D.K.S.191 3 года назад

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 3 года назад

conn SCOTT/TIGER@YOURDATABASE_NAME

@manjunathamr1872 9 месяцев назад

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 9 месяцев назад

Same here. I began to hate this oracl😂

@DataScienceCenter 9 месяцев назад

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

@azizfatima6645 3 года назад

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

@DataScienceCenter 3 года назад

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

@bote6129 2 года назад

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 2 года назад

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

@tasmiar6440 2 года назад

@@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 2 года назад

@@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;"

@bhargavkapuganti3644 2 года назад

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 6 месяцев назад

Sys as sysdba Password??

@DataScienceCenter 6 месяцев назад

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 2 года назад

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 2 года назад

its mean your database is shutdown. first startup open your database. follow the following video for this: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2pVd8nj-csI.html