This section describes:
How to remove the Oracle HTML DB schema, synonyms, and usersfrom the database without deleting the database.
Open SQL*PLUS and connect as privileged user SYS as SYSDBA
sqlplus sys as sysdbaExecute the following commands:
ALTER SESSION SET CURRENT_SCHEMA = flows_010500;and done!!!
EXEC wwv_flow_upgrade.drop_public_synonyms;
ALTER SESSION SET CURRENT_SCHEMA = SYSTEM;
DROP USER flows_010500 CASCADE;
DROP USER flows_files CASCADE;
DROP USER htmldb_public_user CASCADE;