How to drop all sample schemas one by one in Oracle Database 23c FREE

Channel:
India java frm
Subscribers:
5,740
Published on ● Video Link: https://www.youtube.com/watch?v=bERxUd-hcyI


Category:
Tutorial
Duration: 6:25
4 views
0

1. login to sqlplus like "sys@FREEPDB1 as sysdba". You can directly login to FREEPDB1 pluggable database because you already added entry to tnsnames.ora
2. Execute hr_uninstall.sql, which will drop HR.
3. Execute sh_uninstall.sql, which will drop SH.
4. Execute co_uninstall.sql, which will drop CO.
5. Execute "drop user OE cascade", which will drop OE.
6. Execute "drop user PM cascade", which will drop PM.
7. Now try to login as users HR, OE, PM, SH, and CO. If you are unable to login means all schemas are dropped.

#oracle23c #23c #oracledatabase23c #oracledatabase #oracle #dropschema #dropsampleschemas #sampleschemas #sampledatabase #oracledba #oracleinstallation #oracletutorial



Other Videos By java frm


2023-06-21How to install CO schema in Oracle Database 19c running in Windows - Customer Orders Schema
2023-06-21How to install HR schema in Oracle Database 21c running in Windows - Human Resources Schema
2023-06-21How to install HR schema in Oracle Database 19c running in Windows - Human Resources Schema
2023-06-21How to install HR schema in Oracle Database 12c running in Windows - Human Resources Schema
2023-06-21How to drop all sample schemas (HR,OE,PM,SH,IX,BI) in Oracle Database 21c in single shot
2023-06-21How to drop all sample schemas (HR,OE,PM,SH,IX,BI) in Oracle Database 19c in single shot
2023-06-21How to drop all sample schemas (HR,OE,PM,SH,IX,BI) in Oracle Database 12c in single shot
2023-06-21How to install all sample schemas (HR,OE,PM,SH,IX,BI) in Oracle Database 21c in single shot
2023-06-21How to install all sample schemas (HR,OE,PM,SH,IX,BI) in Oracle Database 19c in single shot
2023-06-21How to install all sample schemas (HR,OE,PM,SH,IX,BI) in Oracle Database 12c in single shot
2023-06-21How to drop all sample schemas one by one in Oracle Database 23c FREE
2023-06-21How to install all sample schemas (HR, OE, SH, PM, CO) one by one in Oracle Database 23c FREE
2023-06-21How to connect pluggable database directly from sql plus in Oracle Database 23c FREE
2023-06-21Playing with FL Studio 21 - Composing Music Patterns using Channel Rack - Music Pattern - 318
2023-06-21Playing with FL Studio 21 - Composing Music Patterns using Channel Rack - Music Pattern - 317
2023-06-21Playing with FL Studio 21 - Composing Music Patterns using Channel Rack - Music Pattern - 316
2023-06-21Playing with FL Studio 21 - Composing Music Patterns using Channel Rack - Music Pattern - 315
2023-06-21Playing with FL Studio 21 - Composing Music Patterns using Channel Rack - Music Pattern - 314
2023-06-02Red hat Enterprise Linux 8.8 Installation on VirtualBox 7.0 with Guest Additions | RHEL 8.8
2023-06-02Rocky Linux 8.8 Installation on VirtualBox 7.0 with Guest Additions
2023-06-02Oracle Linux 8.8 installation on VirtualBox 7.0 with Guest Additions


Tags:
how to drop all sample schemas in oracle database 23c
drop schema oracle 23c
drop all schema
drop sample schema
drop all oracle schemas in single sql file
how to drop sample schema
drop oracle schema
drop user
delete oracle schema
remove oracle schema
oracle database 23c tutorial
oracle dba
oracle administration
oracle tutorial
oracle db
sql for beginners
oracle sql 23c
23c
drop hr schema