How to install OE schema in Oracle Database 21c running in Windows - Order Entry Schema

1. Extract the downloaded oracle sample schema scripts to ORACLE_HOME\demo\schema
2. Change directory to order_entry and Change the __SUB_CWD__ to absolute path in sql files wherever necessary as shown in the video.
4. Check the orclpdb is opened in read write mode before executing the queries, else execute this query
alter pluggable database orclpdb open read write;
7. After executing check the logs for any errors if no errors you are done.
8. Open the SQL Developer and login as oe/oe and service name as "orclpdb" and check all objects are available in the schema.

Sample database schema can be downloaded from:

Important Note: Since I am installing in my local machines i will be using connection string as "orclpdb" input while installation of some schemas.
"localhost:1521/orclpdb" also valid connection string.

#oracledatabase #oracledatabase21c #oracledba #oracletutorial #oracle #installsampleschemas #sampleschemas #sampledatabase #oeschema #oe #oracle21c