My Oracle Support Banner

APEX Install Failing with ORA-01920: user name 'FLOWS_FILES' conflicts with another user or role name (Doc ID 2684814.1)

Last updated on FEBRUARY 18, 2021

Applies to:

Oracle Application Express (APEX) - Version 18.2 and later
Information in this document applies to any platform.

Symptoms

APEX install is failing with following errors.


. Application Express (APEX) Installation.
..........................................
.
...set_appun.sql
... Checking prerequisites (MANUAL)
...
. PHASES (1,2,3)...

PL/SQL procedure successfully completed.

...

timing for: Bootstrapping
Elapsed: 00:00:02.03
#
# Creating FLOWS_FILES
#
begin
*
ERROR at line 1:
ORA-01920: user name 'FLOWS_FILES' conflicts with another user or role name
ORA-06512: at line 7

timing for: Creating FLOWS_FILES
Elapsed: 00:00:00.03
#
# Creating APEX_PUBLIC_USER
#
APEX_PUBLIC_USER exists.

timing for: Creating APEX_PUBLIC_USER
Elapsed: 00:00:00.00
#
# Creating APEX_GRANTS_FOR_NEW_USERS_ROLE
#
APEX_ADMINISTRATOR_READ_ROLE exists.
APEX_ADMINISTRATOR_ROLE exists.
APEX_GRANTS_FOR_NEW_USERS_ROLE exists.

timing for: Creating APEX_GRANTS_FOR_NEW_USERS_ROLE
Elapsed: 00:00:00.94
#
# Creating SYS Objects
#
...

Elapsed: 00:00:00.31
#
# Creating APEX Tables
#

THESCRIPT
-----------------------
flows_files_new.sql
ERROR:
ORA-01435: user does not exist

...create flows_files
... create wwv_flow_file_objects
create table wwv_flow_file_objects$ (*
ERROR at line 1:
ORA-00955: name is already used by an existing object

create index wwv_flow_files_file_idx on wwv_flow_file_objects$ (security_group_id, filename, flow_id)

...

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.