1. Database Upgrade Guide
  2. Downgrading Oracle Database to an Earlier Release
  3. Downgrading PDBs That Contain Oracle APEX

Downgrading PDBs That Contain Oracle APEX

Use this procedure to avoid INVALID OBJECTS OWNED BY APEX_050000 errors when you downgrade PDBs that contain Oracle APEX (formerly Application Express).

After you downgrade the PDB to an earlier release, enter a SQL statement similar to the following to drop the Oracle APEX user:, where the log file base is drop_apex5: 

$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -b drop_apex5
-c 'PDB1' -- --x'drop user apex_050000 cascade'

In this example, the PDB name is 'PDB1'.

Parent topic: Downgrading Oracle Database to an Earlier Release