How to Install Scott Schema in Oracle 19C

Published: 18 April 2021
on channel: Data Science Center

13,646

127

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\rdbms\admin\scott.sql
Edit scott.sql
add the service name or pluggable database name in file
connect scott/tiger@orclpdb

Watch video How to Install Scott Schema in Oracle 19C online, duration hours minute second in high quality that is uploaded to the channel Data Science Center 18 April 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 13,646 times and liked it 127 visitors.

465,817

2.5K