Drop objects:
drop user ORDS_METADATA cascade;drop user ORDS_PUBLIC_USER cascade;
drop role ORDS_ADMINISTRATOR_ROLE;drop role ORDS_RUNTIME_ROLE;
beginfor rs in ( select 'DROP PUBLIC SYNONYM ' || OBJECT_NAME sqlstmt from all_objects where object_name like 'ORDS%' and object_type='SYNONYM' order by 1) loop execute immediate rs.sqlstmt; end loop;end;/Delete folders which have ORDS config files
C:\oracle\VIS\ords\bin\global
C:\oracle\VIS\ords\bin\database
The APEX and ORDS installations create these new database users:
| Username | Status |
|---|---|
| APEX_240200 | LOCKED |
| APEX_PUBLIC_ROUTER | OPEN |
| APEX_PUBLIC_USER | OPEN |
| FLOWS_FILES | LOCKED |
| ORDS_METADATA | OPEN |
| ORDS_PUBLIC_USER | OPEN |
© 2026 by Christopher Ho. All Rights Reserved