Creation of Pluggable Databases in Oracle 19C || Database Configuration Assistant

Опубликовано: 05 Октябрь 2024
на канале: Data Science Center
14,161
99

Creation of Pluggable Databases in 19c
start dbca
Manage PLUGGABLE DATABASE
CREATE PLUGGABLE DATABASE

show the pluggable database and services:
show pdbs;
select name from v$services;
show list of users;
SELECT USERNAME FROM ALL_USERS;
To add the sample schema path:


@F:\app\DB_HOME\demo\schema\human_resources\hr_main.sql



make changes in TNSNAME.ORA.