After installing latest version of Oracle Oracle 23ai FREE on Windows 10, I installed HR schema. But now, when I try to uninstall the HR schema using SQL PLUS, I get the following error:
HR schema does not exist, no actions performed.
Question: What could be a cause of the error and how can we resolve it?
Remarks:
- I have verified that HR schema exists by logging into HR and running the queries on its tables
employees,departmenstetc. - The hr_uninstall.sql is available on GitHub here. The error occurs at line 75 of it.
Following is the screenshot of my SQL PLUS on Windows 10. AS you can see I first login as sysdba, and then run the hr_uninstall.sql script provided by Oracle team:
SQL*Plus: Release 23.0.0.0.0 - Production on Wed Dec 18 12:29:58 2024
Version 23.6.0.24.10
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to:
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.6.0.24.10
SQL> @C:Oracle_Gendb-sample-schemas-23.3human_resourceshr_uninstall.sql
HR schema does not exist, no actions performed.
PL/SQL procedure successfully completed.
Disconnected from Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.6.0.24.10
SQL>
7