How to Install Scott Schema in Oracle 19C

Опубликовано: 23 Октябрь 2024
на канале: 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