Removing the APEX Release Schema

After you revert to the prior release, remove the Oracle APEX schema.

Removing the APEX Release 26.2 Schema from a Non-CDB

Start SQLcl and connect to the database and execute DROP USER APEX_260200 CASCADE; command.

To remove the release 26.2 schema from a non-CDB:

Start SQLcl and connect to the database where APEX is installed as SYS specifying the SYSDBA role:

On Windows:

<SYSTEM_DRIVE>:\ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: <SYS_password>

On UNIX and Linux:

$ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: <SYS_password>

Execute the following command:
```
DROP USER APEX_260200 CASCADE;
```
Once you have removed the APEX 26.2 schema, you can now attempt the upgrade again.

Removing the APEX Release 26.2 Schema from a CDB

Create text files, start SQLcl and connect to the database execute @remove_apx262_usr.sql.

To remove the release 26.2 schema from a CDB:

Create a new text file named remove_apx262_usr1.sql with the following contents:
```
alter session set current_schema = SYS;
drop user APEX_260200 cascade;
```

Create a second new text file named remove_apx262_usr.sql with the following contents:

set define '^'
whenever sqlerror exit
column :xe_home new_value OH_HOME NOPRINT
variable xe_home varchar2(255)

set serverout on
begin

-- get oracle_home
    sys.dbms_system.get_env('ORACLE_HOME',:xe_home);
    if length(:xe_home) = 0 then
        sys.dbms_output.put_line(lpad('-',80,'-'));
        raise_application_error (

            -20001,
            'Oracle Home environment variable not set' );
    end if;
end;
/
whenever sqlerror continue

set termout off
select :xe_home from sys.dual;
set termout on
host ^OH_HOME/perl/bin/perl -I ^OH_HOME/rdbms/admin ^OH_HOME/rdbms/admin/catcon.pl -b
      remove_apx262_usr remove_apx262_usr.sql

Start SQLcl and connect to the database where APEX is installed as SYS specifying the SYSDBA role:

On Windows:

<SYSTEM_DRIVE>:\ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: <SYS_password>

On UNIX and Linux:

$ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: <SYS_password>

Execute the following command:
```
@remove_apx262_usr.sql
```
Once you have removed the APEX 26.2 schema, you can now attempt the upgrade again.