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