How to drop all sample schemas (HR,OE,PM,SH,IX,BI) in Oracle Database 21c in single shot

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


Category:
Tutorial
Duration: 3:11
0 views
0

1. login to sqlplus like "sys@orclpdb as sysdba". You can directly login to orclpdb pluggable database because you already added entry to tnsnames.ora
2. Execute drop_sch.sql, which will drop all six Schemas (HR, OE, PM, SH, IX and BI).
3. Now try to login as users HR, OE, PM, SH, IX and BI. If you are unable to login means all schemas are dropped.

#oracledatabase #oracledatabase21c #oracledba #oracletutorial #oracle #dropschema #dropsampleschemas #sampleschemas #sampledatabase #oracle21c #21c



Other Videos By java frm


2023-06-21How to install IX and BI schema in Oracle Database 21c - Info Exchange and Bus Intelligence Schemas
2023-06-21How to install IX and BI schema in Oracle Database 19c - Info Exchange and Bus Intelligence Schemas
2023-06-21How to install IX and BI schema in Oracle Database 12c - Info Exchange and Bus Intelligence Schemas
2023-06-21How to drop CO schema in Oracle Database 21c - Customer Orders Schema
2023-06-21How to drop CO schema in Oracle Database 19c - Customer Orders Schema
2023-06-21How to install CO schema in Oracle Database 21c running in Windows - Customer Orders Schema
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


Tags:
how to drop all sample schemas in oracle database 21c
drop schema oracle 21c
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 21c tutorial
oracle dba
oracle administration
oracle tutorial
oracle db
sql for beginners
oracle sql 21c