Appendix 1

Clean up ORDS installation

• Drop objects:

drop user ORDS_METADATA cascade;
drop user ORDS_PUBLIC_USER cascade;

drop role ORDS_ADMINISTRATOR_ROLE;
drop role ORDS_RUNTIME_ROLE;

begin
for 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

| Table of Content |

| Home | Repositories | Blog |

© 2026 by Christopher Ho. All Rights Reserved