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